Thursday, May 01, 2008

Excel & SQL Server date epochs

Just been caught out by this and so documenting it.

On Excel 2003
1 formatted as date = 1900-01-01

On SQL Server 2000
SELECT CONVERT(CHAR(8), CAST(1 AS DATETIME), 112) = 1900-01-02

Yes, the dates are out by a day.

Yes, this was very frustrating to discover.

2 comments:

  1. Reproduction associated with something can't final for hundreds of years, however should you purchase breitling replica sale from the secure location after that it may final with regard to lengthy. Great stores maintain wide selection associated with hublot replica in various thrilling designs as well as designs. If you would like some thing to appear excellent in your arm as well as simultaneously conserve shades associated with cash use with regard to hublot replica. The 2nd kind of phony cartier replica for sale is actually 1 that isn't various within style, form, as well as colours compared to unique period items as well as the caliber of the actual view is actually fairly comparable and also the exact same associated with top quality fake tag heuer appear therefore incredible which anyone wearing it may appear completely spectacular.

    ReplyDelete
  2. Reproduction associated with something can't final for hundreds of years, however should you purchase breitling replica sale from the secure location after that it may final with regard to lengthy. Great stores maintain wide selection associated with hublot replica in various thrilling designs as well as designs. If you would like some thing to appear excellent in your arm as well as simultaneously conserve shades associated with cash use with regard to hublot replica. The 2nd kind of phony cartier replica for sale is actually 1 that isn't various within style, form, as well as colours compared to unique period items as well as the caliber of the actual view is actually fairly comparable and also the exact same associated with top quality fake tag heuer appear therefore incredible which anyone wearing it may appear completely spectacular.

    ReplyDelete