vk-kirov (4/2/2010)

---

Why the question specifies the slash datetime format (yyyy/mm/dd) while all the answers are in the dash datetime format (yyyy-mm-dd)? This is completely misleading and incorrect!

SanjayAttray (4/2/2010)

---

The ultimate guide to the datetime datatypes

http://www.karaszi.com/SQLServer/info_datetime.asp#Why1753

bigM (4/2/2010)

---

Hi all,

This is an extrapolated question from the actual QoD, but I would like to know the reason (coz of knowledge gaining reason)

Why the 'mmm' part in the RESULT section giving a different value than I entered through the character string as shown below.

SET DATEFORMAT MDY
DECLARE @dmy datetime
SELECT @dmy = '12/31/99 12:13:12:012'
SELECT @dmy

RESULT:
1999-12-31 12:13:12.013


Thanks
big[M]

Paul White NZ (4/2/2010)

---

I wonder how long it will be before someone complains that this QotD is misleading and incorrect since the question specifies "(yyyy/mm/dd)" format and the answers are all in YYYY-MM-DD format?