Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sasidhar Pulivarthi DateTime data types RE: DateTime data types

  • April 12, 2013 at 10:24 am

    #1606043

    demonfox (4/11/2013)

    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

    Thank You