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

Hi Naomi,

I would not use CAST even in USA. I would not use CAST in a foreign language setting for sure.

With proper T-SQL usage, everything works ok using 'YYYY-MM-DD':

SET LANGUAGE french
GO
SELECT CONVERT(date,'2013-12-11');                        -- 2013-12-11
SELECT CONVERT(datetime, '2013-12-11', 111);  -- 2013-12-11 00:00:00.000
GO

SET LANGUAGE british
SELECT CONVERT(date,'2013-12-11');                        -- 2013-12-11
SELECT CONVERT(datetime, '2013-12-11', 111);  -- 2013-12-11 00:00:00.000
 GO 

---

Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012