timezone - Determining remote daylight saving in sql server

Question

I want to determine the if daylight saving time is active or not, but in a region different to where my server is located.

My problem is I want to check the daylight saving of London and my server is in Canada; is it possible to find the daylight saving of a different time zone?

Answer 1

You need to deploy a table of DST and look up the DST time for the region you want. DST are published by various organizations and refreshed periodically. What you need to understand is that DST cannot be determined by an algorithm, it can only be looked up as is set by various legislative bodies for various regions, and changes frequently. For example here is the current 2013 DST table. Maintaining your application's DST look-up table current would be a periodic task for your application.