Duncan Pryde (4/13/2011)

---

Try this:

SET DATEFORMAT ydm
GO
SELECT CAST('2011-04-28' AS DATETIME)

or this:

SET LANGUAGE British
GO
SELECT CAST('2011-04-28' AS DATETIME)

and do the same for the other date types, and you'll see that DATETIME and SMALLDATETIME produce an error while DATE and DATETIME2 don't.

So no guessing required!

Duncan

dennisparks (4/19/2011)

---

All 4 work on my SQL 2008.
bogus question...

dennisparks (4/19/2011)

---

I don't remember the question stating to change the default date setting.
under default settings, they work fine.

Mr Quillz (5/13/2011)

---

Something is wrong with that answer provided.