[thelist] SQL Chaos!!

Jason Handby jasonh at pavilion.co.uk
Wed Jan 29 03:36:00 CST 2003


> actually, datetime values are stored as two 4-byte integers
>
> the first integer, either positive or negative, is the number of
> days before
> or after the base date january 1 1900, with values earlier than january 1
> 1753 not permitted
>
> the second integer is the time of day represented as the number of
> milliseconds after midnight
>
> smalldatetime values are only 2-byte integers, allowing dates only between
> january 1 1900 and june 6 2079, and times only to the minute
>
> http://msdn.microsoft.com/library/en-us/tsqlref/ts_da-db_9xut.asp

Oh. Thanks for putting me straight -- I don't know where I got the idea that
they were stored as floats; I must have got it mixed up with something
else...



Jason





More information about the thelist mailing list