AndyK-565224 (6/6/2012)
I would like to hear a SQL philosopher/historian explain how this situation came about. It seems such a violation of language orthogonality - lying in wait to create bad data.
I agree - it seems like a bad idea.
Found this chart on BOL "Using Date and Time Data"
There are some subtle format differences that seem very arbitrary to me.