Dateime in SQL Server is stored as two 4 byte integers. The first 4 bytes store the # of days from base date 01/01/1900. The second 4 bytes store time portion in 1/300 seconds after midnight.

>What date is returned, 01/01/1900 or 12/31/1899? An offset? Do you mean they are stored as numbers, similar to what VFP does? Would that mean 01/01/1850 would be some negative number, internally?
>
>Dates are kind of a pain when you get down to the nitty gritty, with issues like the Gregorian calendar change, leap years, all that mess with traveling at the speed of light and how that affects time, etc. I'm always having to change the system dates on my computers when I get back from a cruise through the outer galaxy, you know. <g>
>