Tuesday, June 3, 2014
How to convert Excel serial date (integer) to SQL date format
For dates between 01.01.1900 and 28.02.1900 subtract 1 from integer to find correct date.
For dates 01.03.1900 onwards subtract 2 from integer to find correct date.
So it is safe to assume following will work:
SELECT DATEADD(DAY,<VALUE> -2, '01.01.1900')
0 comments:
Post a Comment