Excel & SQL Server date epochs May 01, 2008 database No comments Just been caught out by this and so documenting it.On Excel 20031 formatted as date = 1900-01-01On SQL Server 2000SELECT CONVERT(CHAR(8), CAST(1 AS DATETIME), 112) = 1900-01-02Yes, the dates are out by a day.Yes, this was very frustrating to discover. Share This: Facebook Twitter Stumble Digg Email ThisBlogThis!Share to TwitterShare to Facebook
0 comments:
Post a Comment
I get a lot of comment spam :( - moderation may take a while.