I have to get local date data across many servers scattered around the globe and identify whether it is in daylight saving mode or not ?

Need help.


This is solved in SQL Server 2016 with AT TIME ZONE. And I wrote an article about it here: http://sqlperformance.com/2016/07/sql-plan/at-time-zone

In earlier versions you'll probably need some CLR to read that information from the registry.

  • Awesome..this is exactly what i need..Thank you – Puskar Aug 22 '16 at 6:01
  • "sys.time_zone_info"...Just want to confirm as this is a system table right ? and it gets autorefreshed automatically every year and will have data from around the world? as i dont have sql 2016 installed as of now – Puskar Aug 22 '16 at 6:04
  • It's actually a system view, which hooks into the Windows registry, so it's kept up to date via Windows, not SQL. But you query it as if it's a system table. – Rob Farley Aug 22 '16 at 9:08
  • Cool...thank you very much!! Appreciate your help – Puskar Aug 22 '16 at 18:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.