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',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Wallis','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Efate','+11:00','+11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Ho-Chi-Minh','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/St-Thomas','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Tortola','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Caracas','-04:30','-04:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/St-Vincent','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Vatican','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Samarkand','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Tashkent','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Montevideo','-03:00','-02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Adak','-10:00','-09:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Anchorage','-09:00','-08:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Boise','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Chicago','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Denver','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Detroit','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Indianapolis','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Knox','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Marengo','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Petersburg','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Tell-City','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Valparaiso','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Vevay','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Vincennes','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indiana/Winamac','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Juneau','-09:00','-08:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Kentucky/Louisville','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Kentucky/Monticello','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Los-Angeles','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Menominee','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Metlakatla','-08:00','-08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/New-York','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Nome','-09:00','-08:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/North-Dakota/Beulah','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/North-Dakota/Center','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/North-Dakota/New-Salem','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Phoenix','-07:00','-07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Shiprock','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Sitka','-09:00','-08:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Yakutat','-09:00','-08:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Honolulu','-10:00','-10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Johnston','-10:00','-10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Midway','-11:00','-11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Wake','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Kampala','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Kiev','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Uzhgorod','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Zaporozhye','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Dar-es-Salaam','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Taipei','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Funafuti','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Port-of-Spain','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Istanbul','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Tongatapu','+13:00','+13:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Tunis','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Ashgabat','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Dili','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Fakaofo','+13:00','+13:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Dushanbe','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Bangkok','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Lome','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Kerguelen','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Ndjamena','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Grand-Turk','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Mbabane','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Damascus','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Lower-Princes','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/El-Salvador','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Sao-Tome','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Juba','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Paramaribo','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Mogadishu','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Dakar','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/San-Marino','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Freetown','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Bratislava','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Arctic/Longyearbyen','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Ljubljana','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/St-Helena','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Singapore','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Stockholm','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Khartoum','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Mahe','+04:00','+04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Guadalcanal','+11:00','+11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Riyadh','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Kigali','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Anadyr','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Irkutsk','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Kamchatka','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Khandyga','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Krasnoyarsk','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Magadan','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Novokuznetsk','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Novosibirsk','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Omsk','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Sakhalin','+11:00','+11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Ust-Nera','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Vladivostok','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Yakutsk','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Yekaterinburg','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Kaliningrad','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Moscow','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Samara','+04:00','+04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Simferopol','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Volgograd','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Belgrade','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Bucharest','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Reunion','+04:00','+04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Qatar','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Asuncion','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Palau','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Azores','-01:00','+00:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Madeira','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Lisbon','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Gaza','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Hebron','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Puerto-Rico','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Pitcairn','-08:00','-08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Miquelon','-03:00','-02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Warsaw','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Karachi','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Manila','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Port-Moresby','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Gambier','-09:00','-09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Marquesas','-09:30','-09:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Tahiti','-10:00','-10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Lima','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Panama','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Muscat','+04:00','+04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Auckland','+12:00','+13:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Chatham','+12:45','+13:45',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Niue','-11:00','-11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Nauru','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Kathmandu','+05:45','+05:45',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Oslo','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Amsterdam','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Managua','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Lagos','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Norfolk','+11:30','+11:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Niamey','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Noumea','+11:00','+11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Windhoek','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Maputo','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Kuala-Lumpur','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Kuching','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Bahia-Banderas','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Cancun','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Chihuahua','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Hermosillo','-07:00','-07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Matamoros','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Mazatlan','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Merida','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Mexico-City','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Monterrey','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Ojinaga','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Santa-Isabel','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Tijuana','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Blantyre','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Maldives','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Mauritius','+04:00','+04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Malta','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Montserrat','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Nouakchott','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Martinique','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Saipan','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Macau','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Choibalsan','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Hovd','+07:00','+08:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Ulaanbaatar','+08:00','+09:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Rangoon','+06:30','+06:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Bamako','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Skopje','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Kwajalein','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Majuro','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Antananarivo','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Marigot','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Podgorica','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Chisinau','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Monaco','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Casablanca','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Tripoli','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Riga','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Luxembourg','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Vilnius','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Maseru','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Monrovia','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Colombo','+05:30','+05:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Vaduz','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/St-Lucia','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Beirut','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Vientiane','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Almaty','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Aqtau','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Aqtobe','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Oral','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Qyzylorda','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Cayman','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Kuwait','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Seoul','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Pyongyang','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/St-Kitts','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Comoro','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Enderbury','+13:00','+13:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Kiritimati','+14:00','+14:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Tarawa','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Phnom-Penh','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Bishkek','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Nairobi','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Tokyo','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Amman','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Jamaica','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Jersey','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Rome','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Reykjavik','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Tehran','+03:30','+04:30',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Baghdad','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Chagos','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Kolkata','+05:30','+05:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Isle-of-Man','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Jerusalem','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Dublin','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Jakarta','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Jayapura','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Makassar','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Pontianak','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Budapest','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Port-au-Prince','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Zagreb','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Tegucigalpa','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Hong-Kong','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Guyana','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Bissau','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Guam','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Guatemala','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/South-Georgia','-02:00','-02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Athens','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Malabo','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Guadeloupe','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Conakry','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Banjul','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Danmarkshavn','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Godthab','-03:00','-02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Scoresbysund','-01:00','+00:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Thule','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Gibraltar','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Accra','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Guernsey','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Cayenne','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Tbilisi','+04:00','+04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Grenada','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/London','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Libreville','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Paris','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Faroe','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Chuuk','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Kosrae','+11:00','+11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Pohnpei','+11:00','+11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Stanley','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Fiji','+12:00','+13:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Helsinki','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Addis-Ababa','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Ceuta','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Canary','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Madrid','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Asmara','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/El-Aaiun','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Cairo','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Tallinn','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Guayaquil','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Galapagos','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Algiers','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Santo-Domingo','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Dominica','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Copenhagen','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Djibouti','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Berlin','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Busingen','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Prague','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Nicosia','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Christmas','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Curacao','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Cape-Verde','-01:00','-01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Havana','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Costa-Rica','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Bogota','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Chongqing','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Harbin','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Kashgar','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Shanghai','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Urumqi','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Douala','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Santiago','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Easter','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Rarotonga','-10:00','-10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Abidjan','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Zurich','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Brazzaville','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Bangui','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Kinshasa','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Lubumbashi','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Indian/Cocos','+06:30','+06:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Atikokan','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Blanc-Sablon','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Cambridge-Bay','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Creston','-07:00','-07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Dawson','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Dawson-Creek','-07:00','-07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Edmonton','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Glace-Bay','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Goose-Bay','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Halifax','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Inuvik','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Iqaluit','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Moncton','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Montreal','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Nipigon','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Pangnirtung','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Rainy-River','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Rankin-Inlet','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Regina','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Resolute','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/St-Johns','-03:30','-02:30',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Swift-Current','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Thunder-Bay','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Toronto','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Vancouver','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Whitehorse','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Winnipeg','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Yellowknife','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Belize','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Minsk','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Gaborone','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Thimphu','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Nassau','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Araguaina','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Bahia','-03:00','-02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Belem','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Boa-Vista','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Campo-Grande','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Cuiaba','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Eirunepe','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Fortaleza','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Maceio','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Manaus','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Noronha','-02:00','-02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Porto-Velho','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Recife','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Rio-Branco','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Santarem','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Sao-Paulo','-03:00','-02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Kralendijk','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/La-Paz','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Brunei','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Bermuda','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/St-Barthelemy','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Porto-Novo','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Bujumbura','+02:00','+02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Bahrain','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Sofia','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Ouagadougou','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Brussels','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Dhaka','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Barbados','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Sarajevo','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Baku','+04:00','+05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Mariehamn','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Aruba','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Adelaide','+09:30','+10:30',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Brisbane','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Broken-Hill','+09:30','+10:30',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Currie','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Darwin','+09:30','+09:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Eucla','+08:45','+08:45',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Hobart','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Lindeman','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Lord-Howe','+10:30','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Melbourne','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Perth','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Sydney','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Vienna','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Pago-Pago','-11:00','-11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Buenos-Aires','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Catamarca','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Cordoba','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Jujuy','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/La-Rioja','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Mendoza','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Rio-Gallegos','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Salta','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/San-Juan','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/San-Luis','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Tucuman','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/Ushuaia','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Casey','+11:00','+08:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Davis','+05:00','+07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/DumontDUrville','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Macquarie','+11:00','+11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Mawson','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/McMurdo','+12:00','+13:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Palmer','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Rothera','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/South-Pole','+12:00','+13:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Syowa','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Troll','+00:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Antarctica/Vostok','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Luanda','+01:00','+01:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Yerevan','+04:00','+04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Tirane','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Anguilla','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Antigua','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Kabul','+04:30','+04:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Dubai','+04:00','+04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Andorra','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Asmera','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Africa/Timbuktu','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Argentina/ComodRivadavia','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Atka','-10:00','-09:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Buenos-Aires','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Catamarca','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Coral-Harbour','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Cordoba','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Ensenada','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Fort-Wayne','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Indianapolis','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Jujuy','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Knox-IN','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Louisville','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Mendoza','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Porto-Acre','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Rosario','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('America/Virgin','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Ashkhabad','+05:00','+05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Calcutta','+05:30','+05:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Chungking','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Dacca','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Istanbul','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Katmandu','+05:45','+05:45',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Macao','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Saigon','+07:00','+07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Tel-Aviv','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Thimbu','+06:00','+06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Ujung-Pandang','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Asia/Ulan-Bator','+08:00','+09:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Faeroe','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Atlantic/Jan-Mayen','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/ACT','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Canberra','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/LHI','+10:30','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/North','+09:30','+09:30',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/NSW','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Queensland','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/South','+09:30','+10:30',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Tasmania','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Victoria','+10:00','+11:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/West','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Australia/Yancowinna','+09:30','+10:30',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Brazil/Acre','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Brazil/DeNoronha','-02:00','-02:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Brazil/East','-03:00','-02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Brazil/West','-04:00','-04:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/Atlantic','-04:00','-03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/Central','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/Eastern','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/East-Saskatchewan','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/Mountain','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/Newfoundland','-03:30','-02:30',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/Pacific','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/Saskatchewan','-06:00','-06:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Canada/Yukon','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Chile/Continental','-03:00','-03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Chile/EasterIsland','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Cuba','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Egypt','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Eire','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Etc/GMT','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Etc/GMT+0','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Etc/UCT','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Etc/Universal','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Etc/UTC','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Etc/Zulu','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Belfast','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Nicosia','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Europe/Tiraspol','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('GB','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('GB-Eire','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('GMT','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('GMT+0','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('GMT0','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('GMT-0','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Greenwich','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Hongkong','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Iceland','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Iran','+03:30','+04:30',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Israel','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Jamaica','-05:00','-05:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Japan','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Kwajalein','+12:00','+12:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Libya','+02:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Mexico/BajaNorte','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Mexico/BajaSur','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Mexico/General','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Navajo','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('NZ','+12:00','+13:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('NZ-CHAT','+12:45','+13:45',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Ponape','+11:00','+11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Samoa','-11:00','-11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Truk','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Pacific/Yap','+10:00','+10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Poland','+01:00','+02:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Portugal','+00:00','+01:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('PRC','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('ROC','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('ROK','+09:00','+09:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Singapore','+08:00','+08:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Turkey','+02:00','+03:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('UCT','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Universal','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Alaska','-09:00','-08:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Aleutian','-10:00','-09:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Arizona','-07:00','-07:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Central','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Eastern','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/East-Indiana','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Hawaii','-10:00','-10:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Indiana-Starke','-06:00','-05:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Michigan','-05:00','-04:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Mountain','-07:00','-06:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Pacific','-08:00','-07:00',1);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('US/Samoa','-11:00','-11:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('UTC','+00:00','+00:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('W-SU','+03:00','+03:00',0);
INSERT INTO tzds(tzName,UTCoffset,DSToffset,dayLightSaving) VALUES ('Zulu','+00:00','+00:00',0);

Then you need to know when daylight savings goes into effect

DROP TABLE daylightsavings;
CREATE TABLE daylightsavings(
  Startdt VARCHAR(12) NOT NULL PRIMARY KEY
, Enddt VARCHAR(12)
);
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/11/12 2:00','11/4/12 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/10/13 2:00','11/3/13 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/9/14 2:00','11/2/14 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/8/15 2:00','11/1/15 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/13/16 2:00','11/6/16 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/12/17 2:00','11/5/17 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/11/18 2:00','11/4/18 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/10/19 2:00','11/3/19 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/8/20 2:00','11/1/20 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/14/21 2:00','11/7/21 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/13/22 2:00','11/6/22 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/12/23 2:00','11/5/23 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/10/24 2:00','11/3/24 1:00');
INSERT INTO daylightsavings(Startdt,Enddt) VALUES ('3/9/25 2:00','11/2/25 1:00');

Then a function that will take in a UTC datetime and a desired timezone and will convert it into the correct timezone and apply daylightsavings if required.

-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: JonathanBland
-- Description:
-- =============================================
CREATE PROCEDURE isDayLightSavings 
-- Add the parameters for the stored procedure here
@DateTime datetime = 0, 
@tz varchar(50) = 0 
AS
BEGIN
declare @DayLight as tinyint
--declare @DateTime datetime
--declare @tz varchar(50) 
--set @tz = 'US/Central'
--set @DateTime = '1/1/2015'
set @DayLight = (select 1 from CWFM.dbo.[daylightsavings]
where @DateTime between startdt and enddt
and datepart(year,Startdt) = datepart(year,@DateTime))
if @DayLight = 1
Select DSToffset FROM CWFM.dbo.[tzds]
Where tzName = @tz
else 
Select UTCoffset FROM CWFM.dbo.[tzds]
Where tzName = @tz
END
GO



Comments

Post a Comment

Popular posts from this blog

Understanding & Constructing Dynamic CVP Elements with VFC: Part 1

Our Goal today is to construct a CVP Element that will consume an input string and by using the TTS engine on the Developers box will output audio for our test call. Cisco provides a number of examples of ways to create simple Dynamically configurable elements, you can find a number of them on the Cisco DevNet space for CVP.  Cisco also provides Programming Guides  for the CVP and Element Specifications  (I am linking articles pertaining to CVP 11.0 for simplicity). We will be making use of the Voice Foundation Classes or 'VFC' to construct the VXML content for our Element but before we dive deep into VXML we start we are going to need to create a java class that defines our custom element. public class MyCustomDynamic_Element  extends VoiceElementBase implements ElementInterface { } As you can see we are Implementing the ElementInterface class and Extending the VoiceElementBase class. Next, we are going to need to define the name of our e...
Read more

Creating tar files for Cisco UCM with a Mac

If you have ever felt the frustration of trying to create a tar on a Mac that is going to be used for the bulk uploads on a Cisco Call Manager and experienced it just not working I have a Solution for you!  It took me a little bit to figure this out and while I haven't totally understood why this is the case but it has to do with the fact does not use the GNU archiving utility. I found this and it works. About the App App name : gnu-tar App description : GNU version of the tar archiving utility App website :  https://www.gnu.org/software/tar/ Install the App Press  Command+Space  and type  Terminal  and press  enter/return  key. Run in Terminal app: ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" < /dev/null 2> /dev/null and press  enter/return  key. Wait for the command to finish. Run: brew install gnu-tar Done! You can now use   gnu-tar .   Example: ...
Read more

PCCE 11.x Multi-Line Not Working

This is a step to take if you have made sure your configuration is correct but the changes are not taking effect. After going live our customer detailed that they required Multi Line Agents, Multi Line means that their agents had an ACD line and a Non-ACD Line and that when they picked up their Non-ACD line their ACD line need to go into "Not Ready". After following the Instructions set by Cisco in  Cisco Packaged Contact Center Enterprise Administration and Configuration Guide, Release 11.0(1)   Select Single Line or All Lines to indicate whether all agents supported on the agent peripheral can have one or more than one line configured. Important: If you select All Lines, you must access Cisco Unified Communications Manager to set Busy Trigger to 1 and Max Number of Calls to 2 for each phone. Use the Unified Communications Manager Bulk Administration tool to change these settings for all agent devices. If you change the Agent Phone Line Control setting, you mus...
Read more