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?
Remus Rusanu :
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.",
2013-04-26T08:58:55
bruno.bologna :
On Sql Server 2016:\n\nWith sys.time_zone_info now you can query if a specific timezone is currently on DST.\n\nselect * from sys.time_zone_info\n\n\nHere you have an example result\n\nname current_utc_offset is_currently_dst\nAleutian Standard Time -09:00 1\nHawaiian Standard Time -10:00 0\nMarquesas Standard Time -09:30 0\nAlaskan Standard Time -08:00 1\n",
2017-05-22T19:12:27