Skip to content

Instantly share code, notes, and snippets.

@randyburden
Created February 11, 2024 21:33
Show Gist options
  • Save randyburden/32d1c5e4a41f5e8fb4300f43519253b1 to your computer and use it in GitHub Desktop.
Save randyburden/32d1c5e4a41f5e8fb4300f43519253b1 to your computer and use it in GitHub Desktop.
MySQL TimeZone name table for converting between Windows TimeZone name and IANA TimeZone name
/* MySQL TimeZone name table for converting between Windows TimeZone name and IANA TimeZone name */
CREATE TABLE IF NOT EXISTS `time_zone` (
`id` bigint(20) NOT NULL,
`iana_time_zone` varchar(50) NOT NULL,
`windows_time_zone` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO time_zone (id, iana_time_zone, windows_time_zone) VALUES
(1, 'Etc/GMT+12', 'Dateline Standard Time'),
(2, 'Etc/GMT+11', 'UTC-11'),
(3, 'Pacific/Pago_Pago', 'UTC-11'),
(4, 'Pacific/Niue', 'UTC-11'),
(5, 'Pacific/Midway', 'UTC-11'),
(6, 'America/Adak', 'Aleutian Standard Time'),
(7, 'Pacific/Honolulu', 'Hawaiian Standard Time'),
(8, 'Pacific/Rarotonga', 'Hawaiian Standard Time'),
(9, 'Pacific/Tahiti', 'Hawaiian Standard Time'),
(10, 'Pacific/Johnston', 'Hawaiian Standard Time'),
(11, 'Etc/GMT+10', 'Hawaiian Standard Time'),
(12, 'Pacific/Marquesas', 'Marquesas Standard Time'),
(13, 'America/Anchorage', 'Alaskan Standard Time'),
(14, 'America/Juneau', 'Alaskan Standard Time'),
(15, 'America/Metlakatla', 'Alaskan Standard Time'),
(16, 'America/Nome', 'Alaskan Standard Time'),
(17, 'America/Sitka', 'Alaskan Standard Time'),
(18, 'America/Yakutat', 'Alaskan Standard Time'),
(19, 'Etc/GMT+9', 'UTC-09'),
(20, 'Pacific/Gambier', 'UTC-09'),
(21, 'America/Tijuana', 'Pacific Standard Time (Mexico)'),
(22, 'America/Santa_Isabel', 'Pacific Standard Time (Mexico)'),
(23, 'Etc/GMT+8', 'UTC-08'),
(24, 'Pacific/Pitcairn', 'UTC-08'),
(25, 'America/Los_Angeles', 'Pacific Standard Time'),
(26, 'America/Vancouver', 'Pacific Standard Time'),
(27, 'America/Dawson', 'Pacific Standard Time'),
(28, 'America/Whitehorse', 'Pacific Standard Time'),
(29, 'PST8PDT', 'Pacific Standard Time'),
(30, 'America/Phoenix', 'US Mountain Standard Time'),
(31, 'America/Dawson_Creek', 'US Mountain Standard Time'),
(32, 'America/Creston', 'US Mountain Standard Time'),
(33, 'America/Fort_Nelson', 'US Mountain Standard Time'),
(34, 'America/Hermosillo', 'US Mountain Standard Time'),
(35, 'Etc/GMT+7', 'US Mountain Standard Time'),
(36, 'America/Chihuahua', 'Mountain Standard Time (Mexico)'),
(37, 'America/Mazatlan', 'Mountain Standard Time (Mexico)'),
(38, 'America/Denver', 'Mountain Standard Time'),
(39, 'America/Edmonton', 'Mountain Standard Time'),
(40, 'America/Cambridge_Bay', 'Mountain Standard Time'),
(41, 'America/Inuvik', 'Mountain Standard Time'),
(42, 'America/Yellowknife', 'Mountain Standard Time'),
(43, 'America/Ojinaga', 'Mountain Standard Time'),
(44, 'America/Boise', 'Mountain Standard Time'),
(45, 'MST7MDT', 'Mountain Standard Time'),
(46, 'America/Guatemala', 'Central America Standard Time'),
(47, 'America/Belize', 'Central America Standard Time'),
(48, 'America/Costa_Rica', 'Central America Standard Time'),
(49, 'Pacific/Galapagos', 'Central America Standard Time'),
(50, 'America/Tegucigalpa', 'Central America Standard Time'),
(51, 'America/Managua', 'Central America Standard Time'),
(52, 'America/El_Salvador', 'Central America Standard Time'),
(53, 'Etc/GMT+6', 'Central America Standard Time'),
(54, 'America/Chicago', 'Central Standard Time'),
(55, 'America/Winnipeg', 'Central Standard Time'),
(56, 'America/Rainy_River', 'Central Standard Time'),
(57, 'America/Rankin_Inlet', 'Central Standard Time'),
(58, 'America/Resolute', 'Central Standard Time'),
(59, 'America/Matamoros', 'Central Standard Time'),
(60, 'America/Indiana/Knox', 'Central Standard Time'),
(61, 'America/Indiana/Tell_City', 'Central Standard Time'),
(62, 'America/Menominee', 'Central Standard Time'),
(63, 'America/North_Dakota/Beulah', 'Central Standard Time'),
(64, 'America/North_Dakota/Center', 'Central Standard Time'),
(65, 'America/North_Dakota/New_Salem', 'Central Standard Time'),
(66, 'CST6CDT', 'Central Standard Time'),
(67, 'Pacific/Easter', 'Easter Island Standard Time'),
(68, 'America/Mexico_City', 'Central Standard Time (Mexico)'),
(69, 'America/Bahia_Banderas', 'Central Standard Time (Mexico)'),
(70, 'America/Merida', 'Central Standard Time (Mexico)'),
(71, 'America/Monterrey', 'Central Standard Time (Mexico)'),
(72, 'America/Regina', 'Canada Central Standard Time'),
(73, 'America/Swift_Current', 'Canada Central Standard Time'),
(74, 'America/Bogota', 'SA Pacific Standard Time'),
(75, 'America/Rio_Branco', 'SA Pacific Standard Time'),
(76, 'America/Eirunepe', 'SA Pacific Standard Time'),
(77, 'America/Coral_Harbour', 'SA Pacific Standard Time'),
(78, 'America/Guayaquil', 'SA Pacific Standard Time'),
(79, 'America/Jamaica', 'SA Pacific Standard Time'),
(80, 'America/Cayman', 'SA Pacific Standard Time'),
(81, 'America/Panama', 'SA Pacific Standard Time'),
(82, 'America/Lima', 'SA Pacific Standard Time'),
(83, 'Etc/GMT+5', 'SA Pacific Standard Time'),
(84, 'America/Cancun', 'Eastern Standard Time (Mexico)'),
(85, 'America/New_York', 'Eastern Standard Time'),
(86, 'America/Nassau', 'Eastern Standard Time'),
(87, 'America/Toronto', 'Eastern Standard Time'),
(88, 'America/Iqaluit', 'Eastern Standard Time'),
(89, 'America/Montreal', 'Eastern Standard Time'),
(90, 'America/Nipigon', 'Eastern Standard Time'),
(91, 'America/Pangnirtung', 'Eastern Standard Time'),
(92, 'America/Thunder_Bay', 'Eastern Standard Time'),
(93, 'America/Detroit', 'Eastern Standard Time'),
(94, 'America/Indiana/Petersburg', 'Eastern Standard Time'),
(95, 'America/Indiana/Vincennes', 'Eastern Standard Time'),
(96, 'America/Indiana/Winamac', 'Eastern Standard Time'),
(97, 'America/Kentucky/Monticello', 'Eastern Standard Time'),
(98, 'America/Louisville', 'Eastern Standard Time'),
(99, 'EST5EDT', 'Eastern Standard Time'),
(100, 'America/Port-au-Prince', 'Haiti Standard Time'),
(101, 'America/Havana', 'Cuba Standard Time'),
(102, 'America/Indianapolis', 'US Eastern Standard Time'),
(103, 'America/Indiana/Marengo', 'US Eastern Standard Time'),
(104, 'America/Indiana/Vevay', 'US Eastern Standard Time'),
(105, 'America/Grand_Turk', 'Turks And Caicos Standard Time'),
(106, 'America/Asuncion', 'Paraguay Standard Time'),
(107, 'America/Halifax', 'Atlantic Standard Time'),
(108, 'Atlantic/Bermuda', 'Atlantic Standard Time'),
(109, 'America/Glace_Bay', 'Atlantic Standard Time'),
(110, 'America/Goose_Bay', 'Atlantic Standard Time'),
(111, 'America/Moncton', 'Atlantic Standard Time'),
(112, 'America/Thule', 'Atlantic Standard Time'),
(113, 'America/Caracas', 'Venezuela Standard Time'),
(114, 'America/Cuiaba', 'Central Brazilian Standard Time'),
(115, 'America/Campo_Grande', 'Central Brazilian Standard Time'),
(116, 'America/La_Paz', 'SA Western Standard Time'),
(117, 'America/Antigua', 'SA Western Standard Time'),
(118, 'America/Anguilla', 'SA Western Standard Time'),
(119, 'America/Aruba', 'SA Western Standard Time'),
(120, 'America/Barbados', 'SA Western Standard Time'),
(121, 'America/St_Barthelemy', 'SA Western Standard Time'),
(122, 'America/Kralendijk', 'SA Western Standard Time'),
(123, 'America/Manaus', 'SA Western Standard Time'),
(124, 'America/Boa_Vista', 'SA Western Standard Time'),
(125, 'America/Porto_Velho', 'SA Western Standard Time'),
(126, 'America/Blanc-Sablon', 'SA Western Standard Time'),
(127, 'America/Curacao', 'SA Western Standard Time'),
(128, 'America/Dominica', 'SA Western Standard Time'),
(129, 'America/Santo_Domingo', 'SA Western Standard Time'),
(130, 'America/Grenada', 'SA Western Standard Time'),
(131, 'America/Guadeloupe', 'SA Western Standard Time'),
(132, 'America/Guyana', 'SA Western Standard Time'),
(133, 'America/St_Kitts', 'SA Western Standard Time'),
(134, 'America/St_Lucia', 'SA Western Standard Time'),
(135, 'America/Marigot', 'SA Western Standard Time'),
(136, 'America/Martinique', 'SA Western Standard Time'),
(137, 'America/Montserrat', 'SA Western Standard Time'),
(138, 'America/Puerto_Rico', 'SA Western Standard Time'),
(139, 'America/Lower_Princes', 'SA Western Standard Time'),
(140, 'America/Port_of_Spain', 'SA Western Standard Time'),
(141, 'America/St_Vincent', 'SA Western Standard Time'),
(142, 'America/Tortola', 'SA Western Standard Time'),
(143, 'America/St_Thomas', 'SA Western Standard Time'),
(144, 'Etc/GMT+4', 'SA Western Standard Time'),
(145, 'America/Santiago', 'Pacific SA Standard Time'),
(146, 'America/St_Johns', 'Newfoundland Standard Time'),
(147, 'America/Araguaina', 'Tocantins Standard Time'),
(148, 'America/Sao_Paulo', 'E. South America Standard Time'),
(149, 'America/Cayenne', 'SA Eastern Standard Time'),
(150, 'Antarctica/Rothera', 'SA Eastern Standard Time'),
(151, 'Antarctica/Palmer', 'SA Eastern Standard Time'),
(152, 'America/Fortaleza', 'SA Eastern Standard Time'),
(153, 'America/Belem', 'SA Eastern Standard Time'),
(154, 'America/Maceio', 'SA Eastern Standard Time'),
(155, 'America/Recife', 'SA Eastern Standard Time'),
(156, 'America/Santarem', 'SA Eastern Standard Time'),
(157, 'Atlantic/Stanley', 'SA Eastern Standard Time'),
(158, 'America/Paramaribo', 'SA Eastern Standard Time'),
(159, 'Etc/GMT+3', 'SA Eastern Standard Time'),
(160, 'America/Buenos_Aires', 'Argentina Standard Time'),
(161, 'America/Argentina/La_Rioja', 'Argentina Standard Time'),
(162, 'America/Argentina/Rio_Gallegos', 'Argentina Standard Time'),
(163, 'America/Argentina/Salta', 'Argentina Standard Time'),
(164, 'America/Argentina/San_Juan', 'Argentina Standard Time'),
(165, 'America/Argentina/San_Luis', 'Argentina Standard Time'),
(166, 'America/Argentina/Tucuman', 'Argentina Standard Time'),
(167, 'America/Argentina/Ushuaia', 'Argentina Standard Time'),
(168, 'America/Catamarca', 'Argentina Standard Time'),
(169, 'America/Cordoba', 'Argentina Standard Time'),
(170, 'America/Jujuy', 'Argentina Standard Time'),
(171, 'America/Mendoza', 'Argentina Standard Time'),
(172, 'America/Godthab', 'Greenland Standard Time'),
(173, 'America/Montevideo', 'Montevideo Standard Time'),
(174, 'America/Punta_Arenas', 'Magallanes Standard Time'),
(175, 'America/Miquelon', 'Saint Pierre Standard Time'),
(176, 'America/Bahia', 'Bahia Standard Time'),
(177, 'Etc/GMT+2', 'UTC-02'),
(178, 'America/Noronha', 'UTC-02'),
(179, 'Atlantic/South_Georgia', 'UTC-02'),
(180, 'Atlantic/Azores', 'Azores Standard Time'),
(181, 'America/Scoresbysund', 'Azores Standard Time'),
(182, 'Atlantic/Cape_Verde', 'Cape Verde Standard Time'),
(183, 'Etc/GMT+1', 'Cape Verde Standard Time'),
(184, 'Etc/GMT', 'UTC'),
(185, 'America/Danmarkshavn', 'UTC'),
(186, 'Etc/UTC', 'UTC'),
(187, 'Europe/London', 'GMT Standard Time'),
(188, 'Atlantic/Canary', 'GMT Standard Time'),
(189, 'Atlantic/Faeroe', 'GMT Standard Time'),
(190, 'Europe/Guernsey', 'GMT Standard Time'),
(191, 'Europe/Dublin', 'GMT Standard Time'),
(192, 'Europe/Isle_of_Man', 'GMT Standard Time'),
(193, 'Europe/Jersey', 'GMT Standard Time'),
(194, 'Europe/Lisbon', 'GMT Standard Time'),
(195, 'Atlantic/Madeira', 'GMT Standard Time'),
(196, 'Atlantic/Reykjavik', 'Greenwich Standard Time'),
(197, 'Africa/Ouagadougou', 'Greenwich Standard Time'),
(198, 'Africa/Abidjan', 'Greenwich Standard Time'),
(199, 'Africa/Accra', 'Greenwich Standard Time'),
(200, 'Africa/Banjul', 'Greenwich Standard Time'),
(201, 'Africa/Conakry', 'Greenwich Standard Time'),
(202, 'Africa/Bissau', 'Greenwich Standard Time'),
(203, 'Africa/Monrovia', 'Greenwich Standard Time'),
(204, 'Africa/Bamako', 'Greenwich Standard Time'),
(205, 'Africa/Nouakchott', 'Greenwich Standard Time'),
(206, 'Atlantic/St_Helena', 'Greenwich Standard Time'),
(207, 'Africa/Freetown', 'Greenwich Standard Time'),
(208, 'Africa/Dakar', 'Greenwich Standard Time'),
(209, 'Africa/Lome', 'Greenwich Standard Time'),
(210, 'Africa/Sao_Tome', 'Sao Tome Standard Time'),
(211, 'Africa/Casablanca', 'Morocco Standard Time'),
(212, 'Africa/El_Aaiun', 'Morocco Standard Time'),
(213, 'Europe/Berlin', 'W. Europe Standard Time'),
(214, 'Europe/Andorra', 'W. Europe Standard Time'),
(215, 'Europe/Vienna', 'W. Europe Standard Time'),
(216, 'Europe/Zurich', 'W. Europe Standard Time'),
(217, 'Europe/Busingen', 'W. Europe Standard Time'),
(218, 'Europe/Gibraltar', 'W. Europe Standard Time'),
(219, 'Europe/Rome', 'W. Europe Standard Time'),
(220, 'Europe/Vaduz', 'W. Europe Standard Time'),
(221, 'Europe/Luxembourg', 'W. Europe Standard Time'),
(222, 'Europe/Monaco', 'W. Europe Standard Time'),
(223, 'Europe/Malta', 'W. Europe Standard Time'),
(224, 'Europe/Amsterdam', 'W. Europe Standard Time'),
(225, 'Europe/Oslo', 'W. Europe Standard Time'),
(226, 'Europe/Stockholm', 'W. Europe Standard Time'),
(227, 'Arctic/Longyearbyen', 'W. Europe Standard Time'),
(228, 'Europe/San_Marino', 'W. Europe Standard Time'),
(229, 'Europe/Vatican', 'W. Europe Standard Time'),
(230, 'Europe/Budapest', 'Central Europe Standard Time'),
(231, 'Europe/Tirane', 'Central Europe Standard Time'),
(232, 'Europe/Prague', 'Central Europe Standard Time'),
(233, 'Europe/Podgorica', 'Central Europe Standard Time'),
(234, 'Europe/Belgrade', 'Central Europe Standard Time'),
(235, 'Europe/Ljubljana', 'Central Europe Standard Time'),
(236, 'Europe/Bratislava', 'Central Europe Standard Time'),
(237, 'Europe/Paris', 'Romance Standard Time'),
(238, 'Europe/Brussels', 'Romance Standard Time'),
(239, 'Europe/Copenhagen', 'Romance Standard Time'),
(240, 'Europe/Madrid', 'Romance Standard Time'),
(241, 'Africa/Ceuta', 'Romance Standard Time'),
(242, 'Europe/Warsaw', 'Central European Standard Time'),
(243, 'Europe/Sarajevo', 'Central European Standard Time'),
(244, 'Europe/Zagreb', 'Central European Standard Time'),
(245, 'Europe/Skopje', 'Central European Standard Time'),
(246, 'Africa/Lagos', 'W. Central Africa Standard Time'),
(247, 'Africa/Luanda', 'W. Central Africa Standard Time'),
(248, 'Africa/Porto-Novo', 'W. Central Africa Standard Time'),
(249, 'Africa/Kinshasa', 'W. Central Africa Standard Time'),
(250, 'Africa/Bangui', 'W. Central Africa Standard Time'),
(251, 'Africa/Brazzaville', 'W. Central Africa Standard Time'),
(252, 'Africa/Douala', 'W. Central Africa Standard Time'),
(253, 'Africa/Algiers', 'W. Central Africa Standard Time'),
(254, 'Africa/Libreville', 'W. Central Africa Standard Time'),
(255, 'Africa/Malabo', 'W. Central Africa Standard Time'),
(256, 'Africa/Niamey', 'W. Central Africa Standard Time'),
(257, 'Africa/Ndjamena', 'W. Central Africa Standard Time'),
(258, 'Africa/Tunis', 'W. Central Africa Standard Time'),
(259, 'Etc/GMT-1', 'W. Central Africa Standard Time'),
(260, 'Asia/Amman', 'Jordan Standard Time'),
(261, 'Europe/Bucharest', 'GTB Standard Time'),
(262, 'Asia/Nicosia', 'GTB Standard Time'),
(263, 'Asia/Famagusta', 'GTB Standard Time'),
(264, 'Europe/Athens', 'GTB Standard Time'),
(265, 'Asia/Beirut', 'Middle East Standard Time'),
(266, 'Africa/Cairo', 'Egypt Standard Time'),
(267, 'Europe/Chisinau', 'E. Europe Standard Time'),
(268, 'Asia/Damascus', 'Syria Standard Time'),
(269, 'Asia/Hebron', 'West Bank Standard Time'),
(270, 'Asia/Gaza', 'West Bank Standard Time'),
(271, 'Africa/Johannesburg', 'South Africa Standard Time'),
(272, 'Africa/Bujumbura', 'South Africa Standard Time'),
(273, 'Africa/Gaborone', 'South Africa Standard Time'),
(274, 'Africa/Lubumbashi', 'South Africa Standard Time'),
(275, 'Africa/Maseru', 'South Africa Standard Time'),
(276, 'Africa/Blantyre', 'South Africa Standard Time'),
(277, 'Africa/Maputo', 'South Africa Standard Time'),
(278, 'Africa/Kigali', 'South Africa Standard Time'),
(279, 'Africa/Mbabane', 'South Africa Standard Time'),
(280, 'Africa/Lusaka', 'South Africa Standard Time'),
(281, 'Africa/Harare', 'South Africa Standard Time'),
(282, 'Etc/GMT-2', 'South Africa Standard Time'),
(283, 'Europe/Kiev', 'FLE Standard Time'),
(284, 'Europe/Mariehamn', 'FLE Standard Time'),
(285, 'Europe/Sofia', 'FLE Standard Time'),
(286, 'Europe/Tallinn', 'FLE Standard Time'),
(287, 'Europe/Helsinki', 'FLE Standard Time'),
(288, 'Europe/Vilnius', 'FLE Standard Time'),
(289, 'Europe/Riga', 'FLE Standard Time'),
(290, 'Europe/Uzhgorod', 'FLE Standard Time'),
(291, 'Europe/Zaporozhye', 'FLE Standard Time'),
(292, 'Asia/Jerusalem', 'Israel Standard Time'),
(293, 'Europe/Kaliningrad', 'Kaliningrad Standard Time'),
(294, 'Africa/Khartoum', 'Sudan Standard Time'),
(295, 'Africa/Tripoli', 'Libya Standard Time'),
(296, 'Africa/Windhoek', 'Namibia Standard Time'),
(297, 'Asia/Baghdad', 'Arabic Standard Time'),
(298, 'Europe/Istanbul', 'Turkey Standard Time'),
(299, 'Asia/Riyadh', 'Arab Standard Time'),
(300, 'Asia/Bahrain', 'Arab Standard Time'),
(301, 'Asia/Kuwait', 'Arab Standard Time'),
(302, 'Asia/Qatar', 'Arab Standard Time'),
(303, 'Asia/Aden', 'Arab Standard Time'),
(304, 'Europe/Minsk', 'Belarus Standard Time'),
(305, 'Europe/Moscow', 'Russian Standard Time'),
(306, 'Europe/Kirov', 'Russian Standard Time'),
(307, 'Europe/Simferopol', 'Russian Standard Time'),
(308, 'Africa/Nairobi', 'E. Africa Standard Time'),
(309, 'Antarctica/Syowa', 'E. Africa Standard Time'),
(310, 'Africa/Djibouti', 'E. Africa Standard Time'),
(311, 'Africa/Asmera', 'E. Africa Standard Time'),
(312, 'Africa/Addis_Ababa', 'E. Africa Standard Time'),
(313, 'Indian/Comoro', 'E. Africa Standard Time'),
(314, 'Indian/Antananarivo', 'E. Africa Standard Time'),
(315, 'Africa/Mogadishu', 'E. Africa Standard Time'),
(316, 'Africa/Juba', 'E. Africa Standard Time'),
(317, 'Africa/Dar_es_Salaam', 'E. Africa Standard Time'),
(318, 'Africa/Kampala', 'E. Africa Standard Time'),
(319, 'Indian/Mayotte', 'E. Africa Standard Time'),
(320, 'Etc/GMT-3', 'E. Africa Standard Time'),
(321, 'Asia/Tehran', 'Iran Standard Time'),
(322, 'Asia/Dubai', 'Arabian Standard Time'),
(323, 'Asia/Muscat', 'Arabian Standard Time'),
(324, 'Etc/GMT-4', 'Arabian Standard Time'),
(325, 'Europe/Astrakhan', 'Astrakhan Standard Time'),
(326, 'Europe/Ulyanovsk', 'Astrakhan Standard Time'),
(327, 'Asia/Baku', 'Azerbaijan Standard Time'),
(328, 'Europe/Samara', 'Russia Time Zone 3'),
(329, 'Indian/Mauritius', 'Mauritius Standard Time'),
(330, 'Indian/Reunion', 'Mauritius Standard Time'),
(331, 'Indian/Mahe', 'Mauritius Standard Time'),
(332, 'Europe/Saratov', 'Saratov Standard Time'),
(333, 'Asia/Tbilisi', 'Georgian Standard Time'),
(334, 'Europe/Volgograd', 'Volgograd Standard Time'),
(335, 'Asia/Yerevan', 'Caucasus Standard Time'),
(336, 'Asia/Kabul', 'Afghanistan Standard Time'),
(337, 'Asia/Tashkent', 'West Asia Standard Time'),
(338, 'Antarctica/Mawson', 'West Asia Standard Time'),
(339, 'Asia/Oral', 'West Asia Standard Time'),
(340, 'Asia/Aqtau', 'West Asia Standard Time'),
(341, 'Asia/Aqtobe', 'West Asia Standard Time'),
(342, 'Asia/Atyrau', 'West Asia Standard Time'),
(343, 'Indian/Maldives', 'West Asia Standard Time'),
(344, 'Indian/Kerguelen', 'West Asia Standard Time'),
(345, 'Asia/Dushanbe', 'West Asia Standard Time'),
(346, 'Asia/Ashgabat', 'West Asia Standard Time'),
(347, 'Asia/Samarkand', 'West Asia Standard Time'),
(348, 'Etc/GMT-5', 'West Asia Standard Time'),
(349, 'Asia/Yekaterinburg', 'Ekaterinburg Standard Time'),
(350, 'Asia/Karachi', 'Pakistan Standard Time'),
(351, 'Asia/Qyzylorda', 'Qyzylorda Standard Time'),
(352, 'Asia/Calcutta', 'India Standard Time'),
(353, 'Asia/Colombo', 'Sri Lanka Standard Time'),
(354, 'Asia/Katmandu', 'Nepal Standard Time'),
(355, 'Asia/Almaty', 'Central Asia Standard Time'),
(356, 'Antarctica/Vostok', 'Central Asia Standard Time'),
(357, 'Asia/Urumqi', 'Central Asia Standard Time'),
(358, 'Indian/Chagos', 'Central Asia Standard Time'),
(359, 'Asia/Bishkek', 'Central Asia Standard Time'),
(360, 'Asia/Qostanay', 'Central Asia Standard Time'),
(361, 'Etc/GMT-6', 'Central Asia Standard Time'),
(362, 'Asia/Dhaka', 'Bangladesh Standard Time'),
(363, 'Asia/Thimphu', 'Bangladesh Standard Time'),
(364, 'Asia/Omsk', 'Omsk Standard Time'),
(365, 'Asia/Rangoon', 'Myanmar Standard Time'),
(366, 'Indian/Cocos', 'Myanmar Standard Time'),
(367, 'Asia/Bangkok', 'SE Asia Standard Time'),
(368, 'Antarctica/Davis', 'SE Asia Standard Time'),
(369, 'Indian/Christmas', 'SE Asia Standard Time'),
(370, 'Asia/Jakarta', 'SE Asia Standard Time'),
(371, 'Asia/Pontianak', 'SE Asia Standard Time'),
(372, 'Asia/Phnom_Penh', 'SE Asia Standard Time'),
(373, 'Asia/Vientiane', 'SE Asia Standard Time'),
(374, 'Asia/Saigon', 'SE Asia Standard Time'),
(375, 'Etc/GMT-7', 'SE Asia Standard Time'),
(376, 'Asia/Barnaul', 'Altai Standard Time'),
(377, 'Asia/Hovd', 'W. Mongolia Standard Time'),
(378, 'Asia/Krasnoyarsk', 'North Asia Standard Time'),
(379, 'Asia/Novokuznetsk', 'North Asia Standard Time'),
(380, 'Asia/Novosibirsk', 'N. Central Asia Standard Time'),
(381, 'Asia/Tomsk', 'Tomsk Standard Time'),
(382, 'Asia/Shanghai', 'China Standard Time'),
(383, 'Asia/Hong_Kong', 'China Standard Time'),
(384, 'Asia/Macau', 'China Standard Time'),
(385, 'Asia/Irkutsk', 'North Asia East Standard Time'),
(386, 'Asia/Singapore', 'Singapore Standard Time'),
(387, 'Antarctica/Casey', 'Singapore Standard Time'),
(388, 'Asia/Brunei', 'Singapore Standard Time'),
(389, 'Asia/Makassar', 'Singapore Standard Time'),
(390, 'Asia/Kuala_Lumpur', 'Singapore Standard Time'),
(391, 'Asia/Kuching', 'Singapore Standard Time'),
(392, 'Asia/Manila', 'Singapore Standard Time'),
(393, 'Etc/GMT-8', 'Singapore Standard Time'),
(394, 'Australia/Perth', 'W. Australia Standard Time'),
(395, 'Asia/Taipei', 'Taipei Standard Time'),
(396, 'Asia/Ulaanbaatar', 'Ulaanbaatar Standard Time'),
(397, 'Asia/Choibalsan', 'Ulaanbaatar Standard Time'),
(398, 'Australia/Eucla', 'Aus Central W. Standard Time'),
(399, 'Asia/Chita', 'Transbaikal Standard Time'),
(400, 'Asia/Tokyo', 'Tokyo Standard Time'),
(401, 'Asia/Jayapura', 'Tokyo Standard Time'),
(402, 'Pacific/Palau', 'Tokyo Standard Time'),
(403, 'Asia/Dili', 'Tokyo Standard Time'),
(404, 'Etc/GMT-9', 'Tokyo Standard Time'),
(405, 'Asia/Pyongyang', 'North Korea Standard Time'),
(406, 'Asia/Seoul', 'Korea Standard Time'),
(407, 'Asia/Yakutsk', 'Yakutsk Standard Time'),
(408, 'Asia/Khandyga', 'Yakutsk Standard Time'),
(409, 'Australia/Adelaide', 'Cen. Australia Standard Time'),
(410, 'Australia/Broken_Hill', 'Cen. Australia Standard Time'),
(411, 'Australia/Darwin', 'AUS Central Standard Time'),
(412, 'Australia/Brisbane', 'E. Australia Standard Time'),
(413, 'Australia/Lindeman', 'E. Australia Standard Time'),
(414, 'Australia/Sydney', 'AUS Eastern Standard Time'),
(415, 'Australia/Melbourne', 'AUS Eastern Standard Time'),
(416, 'Pacific/Port_Moresby', 'West Pacific Standard Time'),
(417, 'Antarctica/DumontDUrville', 'West Pacific Standard Time'),
(418, 'Pacific/Truk', 'West Pacific Standard Time'),
(419, 'Pacific/Guam', 'West Pacific Standard Time'),
(420, 'Pacific/Saipan', 'West Pacific Standard Time'),
(421, 'Etc/GMT-10', 'West Pacific Standard Time'),
(422, 'Australia/Hobart', 'Tasmania Standard Time'),
(423, 'Australia/Currie', 'Tasmania Standard Time'),
(424, 'Asia/Vladivostok', 'Vladivostok Standard Time'),
(425, 'Asia/Ust-Nera', 'Vladivostok Standard Time'),
(426, 'Australia/Lord_Howe', 'Lord Howe Standard Time'),
(427, 'Pacific/Bougainville', 'Bougainville Standard Time'),
(428, 'Asia/Srednekolymsk', 'Russia Time Zone 10'),
(429, 'Asia/Magadan', 'Magadan Standard Time'),
(430, 'Pacific/Norfolk', 'Norfolk Standard Time'),
(431, 'Asia/Sakhalin', 'Sakhalin Standard Time'),
(432, 'Pacific/Guadalcanal', 'Central Pacific Standard Time'),
(433, 'Antarctica/Macquarie', 'Central Pacific Standard Time'),
(434, 'Pacific/Ponape', 'Central Pacific Standard Time'),
(435, 'Pacific/Kosrae', 'Central Pacific Standard Time'),
(436, 'Pacific/Noumea', 'Central Pacific Standard Time'),
(437, 'Pacific/Efate', 'Central Pacific Standard Time'),
(438, 'Etc/GMT-11', 'Central Pacific Standard Time'),
(439, 'Asia/Kamchatka', 'Russia Time Zone 11'),
(440, 'Asia/Anadyr', 'Russia Time Zone 11'),
(441, 'Pacific/Auckland', 'New Zealand Standard Time'),
(442, 'Antarctica/McMurdo', 'New Zealand Standard Time'),
(443, 'Etc/GMT-12', 'UTC+12'),
(444, 'Pacific/Tarawa', 'UTC+12'),
(445, 'Pacific/Majuro', 'UTC+12'),
(446, 'Pacific/Kwajalein', 'UTC+12'),
(447, 'Pacific/Nauru', 'UTC+12'),
(448, 'Pacific/Funafuti', 'UTC+12'),
(449, 'Pacific/Wake', 'UTC+12'),
(450, 'Pacific/Wallis', 'UTC+12'),
(451, 'Pacific/Fiji', 'Fiji Standard Time'),
(452, 'Pacific/Chatham', 'Chatham Islands Standard Time'),
(453, 'Etc/GMT-13', 'UTC+13'),
(454, 'Pacific/Enderbury', 'UTC+13'),
(455, 'Pacific/Fakaofo', 'UTC+13'),
(456, 'Pacific/Tongatapu', 'Tonga Standard Time'),
(457, 'Pacific/Apia', 'Samoa Standard Time'),
(458, 'Pacific/Kiritimati', 'Line Islands Standard Time'),
(459, 'Etc/GMT-14', 'Line Islands Standard Time');
/* Example Usage: Get IANA TimeZone */
SELECT tz.iana_time_zone
FROM time_zone tz
WHERE tz.windows_time_zone = 'Central Standard Time'
ORDER BY Id
LIMIT 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment