Unanswered: How tell sql to consider a value as Date Time
as you know when you want to tell sql to conside a value as STRING, put a " around the value.
i want it for date value, somethin that works like this for me: CONVERT(datetime,'2003-06-07').
in some languages # around the values works, but in sql?
If you present a SQL string that is in the ISO 8601 format (CCYY-MM-DD), anywhere that a date is acceptable, SQL Server will automagically convert it to a date for you. I don't know of any prefix or quote character that will force the conversion.