jlennartz (4/11/2013)
If default values are returned as in your explaination why are not all the values except null returned in this format, "1900-01-01 00:00:00.0000000". How did they get switched to "Jan 1 1900 12:00AM"?
the default conversion style for cast and convert is 0 for datetime and 121 for datetime2 ; that's how !!
ref: http://msdn.microsoft.com/en-gb/library/ms187928.aspx
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: