Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL Server AT TIME ZONE inconsistency RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote 
    select CONVERT(DATETIME2, '1966-04-03T00:00:00.000Z') AT TIME ZONE 'Eastern Standard Time'
select CONVERT(DATETIME2, '1966-04-04T00:00:00.000Z') AT TIME ZONE 'Eastern Standard Time'
    The above code snippet returns the following results 
    1966-04-03 00:00:00.0000000 -05:00
1966-04-04 00:00:00.0000000 -04:00

    According to timeanddate.com, it would appear as if DST didn't start in 1966 until April 24th. So both of these results, in my eyes, should be returning the same -5 offset. I think this is a bug but there may be some strangeness with time zones that I'm unfamiliar with.
    Friday, November 6, 2020 3:21 PM

Answers

All replies