SQL Server time zone

• Dee Dee-422077

  Ten Centuries

  Points: 1082

  More actions

  July 27, 2016 at 5:37 am

  #328668

  Hi,

  The system where SQL server install has windows 10 install with timezone set as UTC-5

  when I run SQL stmt select SYSDATETIMEOFFSET() I got back -4

  I thought SQL is using Windows timezone setting but some how it is one hour less. Any idea how to set it to make the timezone the same?

  Thanks,

  Ddee

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  July 27, 2016 at 11:54 am

  #1892358

  I believe the issue you are running into is that SYSDATETIMEOFFSET() is not Daylight Savings Time aware.

  How you handle the difference depends on numerous things (what you are doing with what data with what time zones blah blah)

  Sue