Get list of all time zones, offsets and DST changes
I need to build a reference table that will contain the time zone, offset value and DST changes for all time zones.  Is there a way I can pull this from the windows server hosting sql server?
August 28th, 2015 5:03pm

Hi Moondaddy,

Can have a look on the below links, hope you will get some information.

Microsoft Daylight Saving Time & Time Zone Blog

http://blogs.technet.com/b/dst2007/

Thanks, SMSVikasK

Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 5:46pm

As you can see from the references SMSVikasK provided, the values change over time as new legislation becomes effective in various regions.  Consequently, your table will need not only the offset and date of change, but the effective dates as well.

August 28th, 2015 7:17pm

Hi Moondaddy,

Can have a look on the below links, hope you will get some information.

Microsoft Daylight Saving Time & Time Zone Blog

http://blogs.technet.com/b/dst2007/

Thanks, SMSVikasK

Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 9:44pm

http://www.timeanddate.com/

It also has lots of other good stuff and links. Watch for crazy places like North Korea and Venezuela :)

August 28th, 2015 9:45pm

Thanks Joe, that's a good site.

Btw, I bought your book 'SQL SQL for Smarties' probably back in the 90s.  its a great book and helped me a lot with tree structures.

Best Regards

Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 9:51pm

Thanks Joe, that's a good site.

Btw, I bought your book 'SQL SQL for Smarties' probably back in the 90s.  its a great book and helped me a lot with tree structures.

Best Regards

Actually, I have a whole book on TREES AND HIERARCHIES IN SQL, and the fifth edition of SQL FOR SMARTIES came out a few years ago. Buy copies! Help me pay my mortgage :)
August 29th, 2015 12:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics