WayneS (4/27/2010)
I was a little bit disappointed that the answer went into how a datatime data type is stored in two ints, and did not discuss why "1" = "1900-01-02".
Same here. So I tried: Select Cast(2 As DateTime)
Select Cast(0 As DateTime)
Select Cast(365 As DateTime)
Select Cast(364 As DateTime) and a few other numbers. It looks like whatever number I put in there is how many days past 1900-01-01 00:00:00.000.