I am trying to populate a table for on SQL 2008 Server which should have start datetime and end datetime for daylight saving for various world time zones. So that I can lookup if a particular date is between startdate and enddate and get UTC offset.
Something like the following table. Checked this link but not sure if I can use it in anyway for the information I am looking for or need something completely different.
I not an SQL expert and finding it really difficult to get solution for this problem which I am facing.
|The Time Zone
||Offset for UTC
View Complete Post