Working w/ Time Zones & Day Light Savings in SQL
First you need a DB of all of the timezones... thank you tzdata~ DROP TABLE tzds; CREATE TABLE tzds( tzName VARCHAR(32) NOT NULL PRIMARY KEY , UTCoffset VARCHAR(6) , DSToffset VARCHAR(6) , dayLightSaving BIT ); INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Harare','+02:00','+02:00',0); INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Lusaka','+02:00','+02:00',0); INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Johannesburg','+02:00','+02:00',0); INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Mayotte','+03:00','+03:00',0); INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Aden','+03:00','+03:00',0); INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Apia','+13:00','+14:00...