Thursday, December 26, 2013

Is 'YYYY-MM-DD' not valid for SQL Server?

Tibor's blog is not out of date and shows that we can not safely use dashed format for datetimes.


SET LANGUAGE british

SELECT CAST('2013-12-25' AS date);

SELECT CAST('2013-12-25' AS datetime);

GO


For every expert, there is an equal and opposite expert. - Becker's Law





My blog




My TechNet articles


No comments:

Post a Comment