Showing posts with label Time Zone Sql. Show all posts
Showing posts with label Time Zone Sql. Show all posts

Tuesday, January 24, 2017

List all timeZones in SQL Format


CREATE TABLE IF NOT EXISTS time_zone_list 
(id int(11) NOT NULL AUTO_INCREMENT,name varchar(50) NOT NULL,display_value varchar(100) NOT NULL,PRIMARY KEY (id))
ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Abidjan', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Accra', 'Ghana Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Addis_Ababa', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Algiers', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Asmara', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Asmera', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bamako', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bangui', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Banjul', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bissau', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Blantyre', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Brazzaville', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bujumbura', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Cairo', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Casablanca', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ceuta', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Conakry', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Dakar', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Dar_es_Salaam', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Djibouti', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Douala', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/El_Aaiun', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Freetown', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Gaborone', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Harare', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Johannesburg', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Juba', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kampala', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Khartoum', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kigali', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kinshasa', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lagos', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Libreville', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lome', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Luanda', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lubumbashi', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lusaka', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Malabo', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Maputo', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Maseru', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Mbabane', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Mogadishu', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Monrovia', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Nairobi', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ndjamena', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Niamey', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Nouakchott', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ouagadougou', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Porto-Novo', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Sao_Tome', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Timbuktu', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Tripoli', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Tunis', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Windhoek', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Adak', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Anchorage', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Anguilla', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Antigua', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Araguaina', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Buenos_Aires', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Catamarca', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/ComodRivadavia', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Cordoba', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Jujuy', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/La_Rioja', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Mendoza', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Rio_Gallegos', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Salta', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/San_Juan', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/San_Luis', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Tucuman', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Ushuaia', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Aruba', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Asuncion', 'Paraguay Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Atikokan', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Atka', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bahia', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bahia_Banderas', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Barbados', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Belem', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Belize', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Blanc-Sablon', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Boa_Vista', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bogota', 'Colombia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Boise', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Buenos_Aires', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cambridge_Bay', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Campo_Grande', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cancun', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Caracas', 'Venezuela Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Catamarca', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cayenne', 'French Guiana Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cayman', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Chicago', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Chihuahua', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Coral_Harbour', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cordoba', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Costa_Rica', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Creston', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cuiaba', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Curacao', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Danmarkshavn', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dawson', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dawson_Creek', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Denver', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Detroit', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dominica', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Edmonton', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Eirunepe', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/El_Salvador', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Ensenada', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fort_Nelson', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fort_Wayne', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fortaleza', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Glace_Bay', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Godthab', 'Western Greenland Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Goose_Bay', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Grand_Turk', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Grenada', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guadeloupe', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guatemala', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guayaquil', 'Ecuador Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guyana', 'Guyana Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Halifax', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Havana', 'Cuba Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Hermosillo', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Indianapolis', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Knox', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Marengo', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Petersburg', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Tell_City', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Vevay', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Vincennes', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Winamac', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indianapolis', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Inuvik', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Iqaluit', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Jamaica', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Jujuy', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Juneau', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kentucky/Louisville', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kentucky/Monticello', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Knox_IN', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kralendijk', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/La_Paz', 'Bolivia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Lima', 'Peru Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Los_Angeles', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Louisville', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Lower_Princes', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Maceio', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Managua', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Manaus', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Marigot', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Martinique', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Matamoros', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mazatlan', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mendoza', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Menominee', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Merida', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Metlakatla', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mexico_City', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Miquelon', 'Pierre & Miquelon Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Moncton', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Monterrey', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montevideo', 'Uruguay Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montreal', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montserrat', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nassau', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/New_York', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nipigon', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nome', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Noronha', 'Fernando de Noronha Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/Beulah', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/Center', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/New_Salem', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Ojinaga', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Panama', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Pangnirtung', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Paramaribo', 'Suriname Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Phoenix', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Port-au-Prince', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Port_of_Spain', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Porto_Acre', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Porto_Velho', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Puerto_Rico', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rainy_River', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rankin_Inlet', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Recife', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Regina', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Resolute', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rio_Branco', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rosario', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santa_Isabel', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santarem', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santiago', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santo_Domingo', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Sao_Paulo', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Scoresbysund', 'Eastern Greenland Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Shiprock', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Sitka', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Barthelemy', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Johns', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Kitts', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Lucia', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Thomas', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Vincent', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Swift_Current', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tegucigalpa', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Thule', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Thunder_Bay', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tijuana', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Toronto', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tortola', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Vancouver', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Virgin', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Whitehorse', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Winnipeg', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Yakutat', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Yellowknife', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Casey', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Davis', 'Davis Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/DumontDUrville', 'Dumont-d''Urville Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Macquarie', 'Macquarie Island Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Mawson', 'Mawson Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/McMurdo', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Palmer', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Rothera', 'Rothera Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/South_Pole', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Syowa', 'Syowa Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Troll', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Vostok', 'Vostok Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Arctic/Longyearbyen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aden', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Almaty', 'Alma-Ata Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Amman', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Anadyr', 'Anadyr Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aqtau', 'Aqtau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aqtobe', 'Aqtobe Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ashgabat', 'Turkmenistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ashkhabad', 'Turkmenistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Baghdad', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bahrain', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Baku', 'Azerbaijan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bangkok', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Beirut', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bishkek', 'Kirgizstan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Brunei', 'Brunei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Calcutta', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chita', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Choibalsan', 'Choibalsan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chongqing', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chungking', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Colombo', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dacca', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Damascus', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dhaka', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dili', 'Timor-Leste Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dubai', 'Gulf Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dushanbe', 'Tajikistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Gaza', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Harbin', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hebron', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ho_Chi_Minh', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hong_Kong', 'Hong Kong Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hovd', 'Hovd Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Irkutsk', 'Irkutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Istanbul', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jakarta', 'West Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jayapura', 'East Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jerusalem', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kabul', 'Afghanistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kamchatka', 'Petropavlovsk-Kamchatski Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Karachi', 'Pakistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kashgar', 'Xinjiang Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kathmandu', 'Nepal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Katmandu', 'Nepal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Khandyga', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kolkata', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Krasnoyarsk', 'Krasnoyarsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuala_Lumpur', 'Malaysia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuching', 'Malaysia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuwait', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Macao', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Macau', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Magadan', 'Magadan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Makassar', 'Central Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Manila', 'Philippines Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Muscat', 'Gulf Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Nicosia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Novokuznetsk', 'Krasnoyarsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Novosibirsk', 'Novosibirsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Omsk', 'Omsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Oral', 'Oral Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Phnom_Penh', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Pontianak', 'West Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Pyongyang', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Qatar', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Qyzylorda', 'Qyzylorda Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Rangoon', 'Myanmar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Riyadh', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Saigon', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Sakhalin', 'Sakhalin Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Samarkand', 'Uzbekistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Seoul', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Shanghai', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Singapore', 'Singapore Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Srednekolymsk', 'Srednekolymsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Taipei', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tashkent', 'Uzbekistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tbilisi', 'Georgia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tehran', 'Iran Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tel_Aviv', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Thimbu', 'Bhutan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Thimphu', 'Bhutan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tokyo', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ujung_Pandang', 'Central Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ulaanbaatar', 'Ulaanbaatar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ulan_Bator', 'Ulaanbaatar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Urumqi', 'Xinjiang Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ust-Nera', 'Ust-Nera Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Vientiane', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Vladivostok', 'Vladivostok Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yakutsk', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yekaterinburg', 'Yekaterinburg Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yerevan', 'Armenia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Azores', 'Azores Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Bermuda', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Canary', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Cape_Verde', 'Cape Verde Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Faeroe', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Faroe', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Jan_Mayen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Madeira', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Reykjavik', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/South_Georgia', 'South Georgia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/St_Helena', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Stanley', 'Falkland Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/ACT', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Adelaide', 'Australian Central Standard Time (South Australia)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Brisbane', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Broken_Hill', 'Australian Central Standard Time (South Australia/New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Canberra', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Currie', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Darwin', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Eucla', 'Australian Central Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Hobart', 'Australian Eastern Standard Time (Tasmania)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/LHI', 'Lord Howe Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Lindeman', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Lord_Howe', 'Lord Howe Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Melbourne', 'Australian Eastern Standard Time (Victoria)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/NSW', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/North', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Perth', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Queensland', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/South', 'Australian Central Standard Time (South Australia)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Sydney', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Tasmania', 'Australian Eastern Standard Time (Tasmania)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Victoria', 'Australian Eastern Standard Time (Victoria)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/West', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Yancowinna', 'Australian Central Standard Time (South Australia/New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/Acre', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/DeNoronha', 'Fernando de Noronha Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/East', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/West', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CET', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CST6CDT', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Atlantic', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Central', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/East-Saskatchewan', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Eastern', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Mountain', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Newfoundland', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Pacific', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Saskatchewan', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Yukon', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Chile/Continental', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Chile/EasterIsland', 'Easter Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Cuba', 'Cuba Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EET', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EST5EDT', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Egypt', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Eire', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+1', 'GMT-01:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+10', 'GMT-10:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+11', 'GMT-11:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+12', 'GMT-12:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+2', 'GMT-02:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+3', 'GMT-03:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+4', 'GMT-04:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+5', 'GMT-05:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+6', 'GMT-06:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+7', 'GMT-07:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+8', 'GMT-08:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+9', 'GMT-09:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-1', 'GMT+01:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-10', 'GMT+10:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-11', 'GMT+11:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-12', 'GMT+12:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-13', 'GMT+13:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-14', 'GMT+14:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-2', 'GMT+02:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-3', 'GMT+03:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-4', 'GMT+04:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-5', 'GMT+05:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-6', 'GMT+06:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-7', 'GMT+07:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-8', 'GMT+08:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-9', 'GMT+09:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Greenwich', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/UCT', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/UTC', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Universal', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Zulu', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Amsterdam', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Andorra', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Athens', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Belfast', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Belgrade', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Berlin', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Bratislava', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Brussels', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Bucharest', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Budapest', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Busingen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Chisinau', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Copenhagen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Dublin', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Gibraltar', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Guernsey', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Helsinki', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Isle_of_Man', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Istanbul', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Jersey', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Kaliningrad', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Kiev', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Lisbon', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Ljubljana', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/London', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Luxembourg', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Madrid', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Malta', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Mariehamn', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Minsk', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Monaco', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Moscow', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Nicosia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Oslo', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Paris', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Podgorica', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Prague', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Riga', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Rome', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Samara', 'Samara Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/San_Marino', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Sarajevo', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Simferopol', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Skopje', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Sofia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Stockholm', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tallinn', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tirane', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tiraspol', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Uzhgorod', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vaduz', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vatican', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vienna', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vilnius', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Volgograd', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Warsaw', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zagreb', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zaporozhye', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zurich', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GB', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GB-Eire', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GMT', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GMT0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Greenwich', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Hongkong', 'Hong Kong Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Iceland', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Antananarivo', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Chagos', 'Indian Ocean Territory Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Christmas', 'Christmas Island Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Cocos', 'Cocos Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Comoro', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Kerguelen', 'French Southern & Antarctic Lands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mahe', 'Seychelles Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Maldives', 'Maldives Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mauritius', 'Mauritius Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mayotte', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Reunion', 'Reunion Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Iran', 'Iran Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Israel', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Jamaica', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Japan', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Kwajalein', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Libya', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MET', 'Middle Europe Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MST7MDT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/BajaNorte', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/BajaSur', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/General', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NZ', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NZ-CHAT', 'Chatham Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Navajo', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PRC', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PST8PDT', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Apia', 'West Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Auckland', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Bougainville', 'Bougainville Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Chatham', 'Chatham Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Chuuk', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Easter', 'Easter Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Efate', 'Vanuatu Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Enderbury', 'Phoenix Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Fakaofo', 'Tokelau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Fiji', 'Fiji Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Funafuti', 'Tuvalu Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Galapagos', 'Galapagos Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Gambier', 'Gambier Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Guadalcanal', 'Solomon Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Guam', 'Chamorro Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Honolulu', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Johnston', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kiritimati', 'Line Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kosrae', 'Kosrae Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kwajalein', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Majuro', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Marquesas', 'Marquesas Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Midway', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Nauru', 'Nauru Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Niue', 'Niue Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Norfolk', 'Norfolk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Noumea', 'New Caledonia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pago_Pago', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Palau', 'Palau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pitcairn', 'Pitcairn Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pohnpei', 'Pohnpei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Ponape', 'Pohnpei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Port_Moresby', 'Papua New Guinea Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Rarotonga', 'Cook Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Saipan', 'Chamorro Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Samoa', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tahiti', 'Tahiti Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tarawa', 'Gilbert Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tongatapu', 'Tonga Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Truk', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Wake', 'Wake Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Wallis', 'Wallis & Futuna Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Yap', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Poland', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Portugal', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ROK', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Singapore', 'Singapore Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/AST4', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/AST4ADT', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/CST6', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/CST6CDT', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/EST5', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/EST5EDT', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/HST10', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/MST7', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/MST7MDT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/PST8', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/PST8PDT', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/YST9', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/YST9YDT', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Turkey', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('UCT', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Alaska', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Aleutian', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Arizona', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Central', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/East-Indiana', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Eastern', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Hawaii', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Indiana-Starke', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Michigan', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Mountain', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Pacific', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Pacific-New', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Samoa', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('UTC', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Universal', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('W-SU', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('WET', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Zulu', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EST', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('HST', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MST', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ACT', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('AET', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('AGT', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ART', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('AST', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('BET', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('BST', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CAT', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CNT', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CST', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CTT', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EAT', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ECT', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('IET', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('IST', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('JST', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MIT', 'West Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NET', 'Armenia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NST', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PLT', 'Pakistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PNT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PRT', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PST', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SST', 'Solomon Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('VST', 'Indochina Time');