Toreador (1/7/2016)

---

Rich Mechaber (1/6/2016)

---

This, for example, throws an error:

SET LANGUAGE british

SELECT CAST('2003-02-28' AS datetime);

Server: Msg 242, Level 16, State 3, Line 4

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

I wonder why that is? Our date format is dd mm yyyy, or yyyy-mm-dd, but never yyyy-dd-mm (at least I've never seen a date expressed in that form)