itsmatta (4/12/2011)

---

All 4 works correctly and I have selected only 2 as per the question.. So I am right and need my point back

itsmatta (4/12/2011)

---

All 4 works correctly and I have selected only 2 as per the question.. So I am right and need my point back

The effect of the DATEFORMAT setting on the interpretation of character strings might be different for datetime and smalldatetime values than for date, datetime2 and datetimeoffset values, depending on the string format.

Henrico Bekker (4/12/2011)

---

All 4 options work? one of those questions again...pick 2 out of 4 correct answers...a quessing game again.

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

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

Nakul Vachhrajani (4/13/2011)

---

Thank-you, Duncan for this wonderful series!