system.kanoa.date.getIANATimeZoneToSQLDict()
Return a dictionary of IANA timezones to SQL timezones Parses CLDR windowsZones.xml and returns a dict mapping each IANA zone to its Windows time zone (Windows ID). Only uses entries where territory="001" (canonical mapping). File can be found at https://github.com/unicode-org/cldr/blob/main/common/supplemental/windowsZones.xml
Parameters
Returns
timeZoneInfo Dictionary
Example
print system.kanoa.date.getIANATimeZoneToSQLDict()
>>>
Asia/Aden Arab Standard Time
America/Cuiaba Central Brazilian Standard Time
Etc/GMT+9 UTC-09
Etc/GMT+8 UTC-08
Africa/Nairobi E. Africa Standard Time
America/Marigot SA Western Standard Time
Asia/Aqtau West Asia Standard Time
Pacific/Kwajalein UTC+12
America/El_Salvador Central America Standard Time
Asia/Pontianak SE Asia Standard Time
Africa/Cairo Egypt Standard Time
Pacific/Pago_Pago UTC-11
Africa/Mbabane South Africa Standard Time
Asia/Kuching Singapore Standard Time
Pacific/Honolulu Hawaiian Standard Time
Pacific/Rarotonga Hawaiian Standard Time
America/Guatemala Central America Standard Time
Australia/Hobart Tasmania Standard Time
Europe/London GMT Standard Time
America/Belize Central America Standard Time
America/Panama SA Pacific Standard Time
America/Managua Central America Standard Time
America/Indiana/Petersburg Eastern Standard Time
Asia/Yerevan Caucasus Standard Time
Europe/Brussels Romance Standard Time
Europe/Warsaw Central European Standard Time
America/Chicago Central Standard Time
Etc/GMT-1 W. Central Africa Standard Time
Europe/Jersey GMT Standard Time
America/Tegucigalpa Central America Standard Time
Etc/GMT-5 West Asia Standard Time
Europe/Istanbul Turkey Standard Time
America/Eirunepe SA Pacific Standard Time
Etc/GMT-4 Arabian Standard Time
America/Miquelon Saint Pierre Standard Time
Etc/GMT-3 E. Africa Standard Time
Europe/Luxembourg W. Europe Standard Time
Etc/GMT-2 South Africa Standard Time
Etc/GMT-9 Tokyo Standard Time
Etc/GMT-8 Singapore Standard Time
Etc/GMT-7 SE Asia Standard Time
Etc/GMT-6 Central Asia Standard Time
Atlantic/St_Helena Greenwich Standard Time
Europe/Guernsey GMT Standard Time
America/Grand_Turk Turks And Caicos Standard Time
Asia/Samarkand West Asia Standard Time
Asia/Phnom_Penh SE Asia Standard Time
Africa/Kigali South Africa Standard Time
Asia/Almaty West Asia Standard Time
Asia/Dubai Arabian Standard Time
Europe/Isle_of_Man GMT Standard Time
America/Araguaina Tocantins Standard Time
Asia/Novosibirsk N. Central Asia Standard Time
America/Argentina/Salta Argentina Standard Time
Etc/GMT+3 SA Eastern Standard Time
Africa/Tunis W. Central Africa Standard Time
Etc/GMT+2 UTC-02
Etc/GMT+1 Cape Verde Standard Time
Pacific/Fakaofo UTC+13
Africa/Tripoli Libya Standard Time
Africa/Banjul Greenwich Standard Time
Etc/GMT+7 US Mountain Standard Time
Indian/Comoro E. Africa Standard Time
Etc/GMT+6 Central America Standard Time
Etc/GMT+5 SA Pacific Standard Time
Etc/GMT+4 SA Western Standard Time
Pacific/Port_Moresby West Pacific Standard Time
Antarctica/Syowa E. Africa Standard Time
Indian/Reunion Mauritius Standard Time
Pacific/Palau Tokyo Standard Time
Europe/Kaliningrad Kaliningrad Standard Time
America/Montevideo Montevideo Standard Time
Africa/Windhoek Namibia Standard Time
Asia/Karachi Pakistan Standard Time
Africa/Mogadishu E. Africa Standard Time
Australia/Perth W. Australia Standard Time
Etc/GMT UTC
Asia/Chita Transbaikal Standard Time
Pacific/Easter Easter Island Standard Time
Antarctica/Davis SE Asia Standard Time
Antarctica/McMurdo New Zealand Standard Time
America/Manaus SA Western Standard Time
Africa/Freetown Greenwich Standard Time
Europe/Bucharest GTB Standard Time
Asia/Tomsk Tomsk Standard Time
Asia/Macau China Standard Time
Europe/Malta W. Europe Standard Time
Pacific/Tahiti Hawaiian Standard Time
Africa/Asmera E. Africa Standard Time
Europe/Busingen W. Europe Standard Time
America/Argentina/Rio_Gallegos Argentina Standard Time
Africa/Malabo W. Central Africa Standard Time
Europe/Skopje Central European Standard Time
America/Catamarca Argentina Standard Time
America/Godthab Greenland Standard Time
Europe/Sarajevo Central European Standard Time
Africa/Lagos W. Central Africa Standard Time
America/Cordoba Argentina Standard Time
Europe/Rome W. Europe Standard Time
Indian/Mauritius Mauritius Standard Time
America/Regina Canada Central Standard Time
America/Dawson_Creek US Mountain Standard Time
Africa/Algiers W. Central Africa Standard Time
Europe/Mariehamn FLE Standard Time
America/St_Thomas SA Western Standard Time
America/St_Johns Newfoundland Standard Time
Europe/Zurich W. Europe Standard Time
America/Anguilla SA Western Standard Time
Asia/Dili Tokyo Standard Time
America/Denver Mountain Standard Time
Africa/Bamako Greenwich Standard Time
Europe/Saratov Saratov Standard Time
Pacific/Wallis UTC+12
Europe/Gibraltar W. Europe Standard Time
Africa/Conakry Greenwich Standard Time
Africa/Lubumbashi South Africa Standard Time
America/Havana Cuba Standard Time
Asia/Omsk Omsk Standard Time
Europe/Vaduz W. Europe Standard Time
Asia/Dhaka Bangladesh Standard Time
America/Barbados SA Western Standard Time
Atlantic/Cape_Verde Cape Verde Standard Time
Asia/Yekaterinburg Ekaterinburg Standard Time
America/Louisville Eastern Standard Time
Pacific/Chatham Chatham Islands Standard Time
Europe/Ljubljana Central Europe Standard Time
America/Sao_Paulo E. South America Standard Time
Asia/Jayapura Tokyo Standard Time
America/Curacao SA Western Standard Time
Asia/Dushanbe West Asia Standard Time
America/Guyana SA Western Standard Time
America/Guayaquil SA Pacific Standard Time
America/Martinique SA Western Standard Time
Europe/Berlin W. Europe Standard Time
Europe/Moscow Russian Standard Time
Europe/Chisinau E. Europe Standard Time
America/Puerto_Rico SA Western Standard Time
America/Rankin_Inlet Central Standard Time
Pacific/Ponape Central Pacific Standard Time
Europe/Stockholm W. Europe Standard Time
Europe/Budapest Central Europe Standard Time
Australia/Eucla Aus Central W. Standard Time
Asia/Shanghai China Standard Time
Europe/Zagreb Central European Standard Time
America/Port_of_Spain SA Western Standard Time
Europe/Helsinki FLE Standard Time
Asia/Beirut Middle East Standard Time
Pacific/Bougainville Bougainville Standard Time
Africa/Sao_Tome Sao Tome Standard Time
Indian/Chagos Central Asia Standard Time
America/Cayenne SA Eastern Standard Time
Asia/Yakutsk Yakutsk Standard Time
Pacific/Galapagos Central America Standard Time
Europe/Paris Romance Standard Time
Africa/Ndjamena W. Central Africa Standard Time
Pacific/Fiji Fiji Standard Time
Indian/Maldives West Asia Standard Time
Asia/Oral West Asia Standard Time
Pacific/Enderbury UTC+13
America/Juneau Alaskan Standard Time
America/Indiana/Vevay US Eastern Standard Time
Asia/Tashkent West Asia Standard Time
Asia/Jakarta SE Asia Standard Time
Africa/Ceuta Romance Standard Time
Asia/Barnaul Altai Standard Time
America/Recife SA Eastern Standard Time
America/Buenos_Aires Argentina Standard Time
America/Noronha UTC-02
America/Swift_Current Canada Central Standard Time
Australia/Adelaide Cen. Australia Standard Time
America/Metlakatla Alaskan Standard Time
Africa/Djibouti E. Africa Standard Time
America/Paramaribo SA Eastern Standard Time
Asia/Qostanay West Asia Standard Time
Europe/Simferopol Russian Standard Time
Europe/Sofia FLE Standard Time
Africa/Nouakchott Greenwich Standard Time
Europe/Prague Central Europe Standard Time
America/Indiana/Vincennes Eastern Standard Time
Antarctica/Mawson West Asia Standard Time
America/Kralendijk SA Western Standard Time
Europe/Samara Russia Time Zone 3
Indian/Christmas SE Asia Standard Time
America/Antigua SA Western Standard Time
Pacific/Gambier UTC-09
America/Indianapolis US Eastern Standard Time
America/Inuvik Mountain Standard Time
America/Iqaluit Eastern Standard Time
Pacific/Funafuti UTC+12
Antarctica/Macquarie Tasmania Standard Time
America/Moncton Atlantic Standard Time
Africa/Gaborone South Africa Standard Time
Asia/Pyongyang North Korea Standard Time
America/St_Vincent SA Western Standard Time
Asia/Gaza West Bank Standard Time
Atlantic/Faeroe GMT Standard Time
Asia/Qyzylorda Qyzylorda Standard Time
America/Yakutat Alaskan Standard Time
America/Ciudad_Juarez Mountain Standard Time
Antarctica/Casey Central Pacific Standard Time
Europe/Copenhagen Romance Standard Time
Atlantic/Azores Azores Standard Time
Europe/Vienna W. Europe Standard Time
Pacific/Pitcairn UTC-08
America/Mazatlan Mountain Standard Time (Mexico)
Pacific/Nauru UTC+12
Europe/Tirane Central Europe Standard Time
Australia/Broken_Hill Cen. Australia Standard Time
Europe/Riga FLE Standard Time
America/Dominica SA Western Standard Time
America/Mendoza Argentina Standard Time
Africa/Abidjan Greenwich Standard Time
America/Santarem SA Eastern Standard Time
America/Asuncion Paraguay Standard Time
America/Boise Mountain Standard Time
Pacific/Guam West Pacific Standard Time
Pacific/Wake UTC+12
Atlantic/Bermuda Atlantic Standard Time
America/Costa_Rica Central America Standard Time
America/Dawson Yukon Standard Time
Europe/Amsterdam W. Europe Standard Time
America/Indiana/Knox Central Standard Time
America/North_Dakota/Beulah Central Standard Time
Africa/Accra Greenwich Standard Time
America/Maceio SA Eastern Standard Time
Pacific/Apia Samoa Standard Time
Pacific/Niue UTC-11
Australia/Lord_Howe Lord Howe Standard Time
Europe/Dublin GMT Standard Time
Pacific/Truk West Pacific Standard Time
America/Monterrey Central Standard Time (Mexico)
America/Nassau Eastern Standard Time
America/Jamaica SA Pacific Standard Time
Asia/Bishkek Central Asia Standard Time
Atlantic/Stanley SA Eastern Standard Time
Indian/Mahe Mauritius Standard Time
Asia/Aqtobe West Asia Standard Time
America/Sitka Alaskan Standard Time
Asia/Vladivostok Vladivostok Standard Time
Africa/Libreville W. Central Africa Standard Time
Africa/Maputo South Africa Standard Time
America/Kentucky/Monticello Eastern Standard Time
America/Coral_Harbour SA Pacific Standard Time
Africa/Ouagadougou Greenwich Standard Time
Africa/El_Aaiun Morocco Standard Time
Pacific/Marquesas Marquesas Standard Time
America/Aruba SA Western Standard Time
America/North_Dakota/Center Central Standard Time
America/Cayman SA Pacific Standard Time
Asia/Ulaanbaatar Ulaanbaatar Standard Time
Asia/Baghdad Arabic Standard Time
Europe/San_Marino W. Europe Standard Time
America/Indiana/Tell_City Central Standard Time
America/Tijuana Pacific Standard Time (Mexico)
Pacific/Saipan West Pacific Standard Time
Africa/Douala W. Central Africa Standard Time
America/Chihuahua Central Standard Time (Mexico)
America/Ojinaga Central Standard Time
Asia/Hovd W. Mongolia Standard Time
America/Anchorage Alaskan Standard Time
America/Halifax Atlantic Standard Time
Antarctica/Rothera SA Eastern Standard Time
Asia/Damascus Syria Standard Time
America/Argentina/San_Luis Argentina Standard Time
America/Santiago Pacific SA Standard Time
Asia/Baku Azerbaijan Standard Time
America/Argentina/Ushuaia Argentina Standard Time
Atlantic/Reykjavik Greenwich Standard Time
Africa/Brazzaville W. Central Africa Standard Time
Africa/Porto-Novo W. Central Africa Standard Time
America/La_Paz SA Western Standard Time
Antarctica/DumontDUrville West Pacific Standard Time
Asia/Taipei Taipei Standard Time
Asia/Manila Singapore Standard Time
Asia/Bangkok SE Asia Standard Time
Africa/Dar_es_Salaam E. Africa Standard Time
Atlantic/Madeira GMT Standard Time
Antarctica/Palmer SA Eastern Standard Time
Africa/Addis_Ababa E. Africa Standard Time
America/Indiana/Marengo US Eastern Standard Time
America/Creston US Mountain Standard Time
America/Punta_Arenas Magallanes Standard Time
America/Mexico_City Central Standard Time (Mexico)
Antarctica/Vostok Central Asia Standard Time
Asia/Jerusalem Israel Standard Time
Europe/Andorra W. Europe Standard Time
America/Coyhaique Magallanes Standard Time
Asia/Vientiane SE Asia Standard Time
Pacific/Kiritimati Line Islands Standard Time
America/Matamoros Central Standard Time
America/Blanc-Sablon SA Western Standard Time
Asia/Riyadh Arab Standard Time
Atlantic/South_Georgia UTC-02
Europe/Lisbon GMT Standard Time
Europe/Oslo W. Europe Standard Time
Asia/Novokuznetsk North Asia Standard Time
Atlantic/Canary GMT Standard Time
Asia/Kuwait Arab Standard Time
Pacific/Efate Central Pacific Standard Time
America/Bogota SA Pacific Standard Time
Africa/Lome Greenwich Standard Time
America/Menominee Central Standard Time
America/Adak Aleutian Standard Time
Pacific/Norfolk Norfolk Standard Time
Europe/Kirov Russian Standard Time
America/Resolute Central Standard Time
Pacific/Tarawa UTC+12
Asia/Krasnoyarsk North Asia Standard Time
Africa/Kampala E. Africa Standard Time
Europe/Podgorica Central Europe Standard Time
America/Edmonton Mountain Standard Time
America/Santo_Domingo SA Western Standard Time
Africa/Bujumbura South Africa Standard Time
Europe/Minsk Belarus Standard Time
Pacific/Auckland New Zealand Standard Time
Africa/Casablanca Morocco Standard Time
America/Glace_Bay Atlantic Standard Time
Asia/Qatar Arab Standard Time
Europe/Kiev FLE Standard Time
Asia/Magadan Magadan Standard Time
America/Port-au-Prince Haiti Standard Time
America/St_Barthelemy SA Western Standard Time
Asia/Ashgabat West Asia Standard Time
Africa/Luanda W. Central Africa Standard Time
Asia/Muscat Arabian Standard Time
Asia/Bahrain Arab Standard Time
Europe/Vilnius FLE Standard Time
America/Fortaleza SA Eastern Standard Time
America/Hermosillo US Mountain Standard Time
America/Cancun Eastern Standard Time (Mexico)
Africa/Maseru South Africa Standard Time
Pacific/Kosrae Central Pacific Standard Time
Africa/Kinshasa W. Central Africa Standard Time
Asia/Seoul Korea Standard Time
Australia/Sydney AUS Eastern Standard Time
America/Lima SA Pacific Standard Time
America/St_Lucia SA Western Standard Time
Europe/Madrid Romance Standard Time
America/Bahia_Banderas Central Standard Time (Mexico)
America/Montserrat SA Western Standard Time
Asia/Brunei Singapore Standard Time
America/Cambridge_Bay Mountain Standard Time
Asia/Colombo Sri Lanka Standard Time
Indian/Antananarivo E. Africa Standard Time
Australia/Brisbane E. Australia Standard Time
Indian/Mayotte E. Africa Standard Time
Asia/Urumqi Central Asia Standard Time
Europe/Volgograd Volgograd Standard Time
America/Lower_Princes SA Western Standard Time
America/Vancouver Pacific Standard Time
Africa/Blantyre South Africa Standard Time
America/Rio_Branco SA Pacific Standard Time
America/Danmarkshavn Greenwich Standard Time
America/Detroit Eastern Standard Time
America/Thule Atlantic Standard Time
Africa/Lusaka South Africa Standard Time
Asia/Hong_Kong China Standard Time
America/Argentina/La_Rioja Argentina Standard Time
Africa/Dakar Greenwich Standard Time
America/Tortola SA Western Standard Time
Asia/Sakhalin Sakhalin Standard Time
America/Porto_Velho SA Western Standard Time
Etc/GMT+10 Hawaiian Standard Time
America/Scoresbysund Azores Standard Time
Asia/Kamchatka Russia Time Zone 11
Africa/Harare South Africa Standard Time
Etc/GMT+12 Dateline Standard Time
Etc/GMT+11 UTC-11
America/Nome Alaskan Standard Time
Europe/Tallinn FLE Standard Time
Africa/Khartoum Sudan Standard Time
Africa/Johannesburg South Africa Standard Time
Africa/Bangui W. Central Africa Standard Time
Europe/Belgrade Central Europe Standard Time
Africa/Bissau Greenwich Standard Time
Asia/Tehran Iran Standard Time
Europe/Astrakhan Astrakhan Standard Time
America/Campo_Grande Central Brazilian Standard Time
Africa/Juba South Sudan Standard Time
America/Belem SA Eastern Standard Time
Asia/Saigon SE Asia Standard Time
Pacific/Midway UTC-11
America/Jujuy Argentina Standard Time
America/Bahia Bahia Standard Time
America/Goose_Bay Atlantic Standard Time
Asia/Katmandu Nepal Standard Time
America/Phoenix US Mountain Standard Time
Africa/Niamey W. Central Africa Standard Time
America/Whitehorse Yukon Standard Time
Pacific/Noumea Central Pacific Standard Time
Asia/Tbilisi Georgian Standard Time
Asia/Makassar Singapore Standard Time
America/Argentina/San_Juan Argentina Standard Time
Asia/Nicosia GTB Standard Time
America/Indiana/Winamac Eastern Standard Time
America/Boa_Vista SA Western Standard Time
America/Grenada SA Western Standard Time
Asia/Atyrau West Asia Standard Time
Australia/Darwin AUS Central Standard Time
Asia/Kuala_Lumpur Singapore Standard Time
Asia/Khandyga Yakutsk Standard Time
Asia/Famagusta GTB Standard Time
Asia/Thimphu Bangladesh Standard Time
Asia/Rangoon Myanmar Standard Time
Europe/Bratislava Central Europe Standard Time
Asia/Calcutta India Standard Time
America/Argentina/Tucuman Argentina Standard Time
Asia/Kabul Afghanistan Standard Time
Indian/Cocos Myanmar Standard Time
Pacific/Tongatapu Tonga Standard Time
America/New_York Eastern Standard Time
Etc/GMT-12 UTC+12
Etc/GMT-11 Central Pacific Standard Time
Etc/GMT-10 West Pacific Standard Time
Europe/Ulyanovsk Astrakhan Standard Time
Etc/GMT-14 Line Islands Standard Time
Etc/GMT-13 UTC+13
America/Merida Central Standard Time (Mexico)
America/St_Kitts SA Western Standard Time
Arctic/Longyearbyen W. Europe Standard Time
America/Fort_Nelson US Mountain Standard Time
America/Caracas Venezuela Standard Time
America/Guadeloupe SA Western Standard Time
Asia/Hebron West Bank Standard Time
Indian/Kerguelen West Asia Standard Time
Africa/Monrovia Greenwich Standard Time
Asia/Ust-Nera Vladivostok Standard Time
Asia/Srednekolymsk Russia Time Zone 10
America/North_Dakota/New_Salem Central Standard Time
Asia/Anadyr Russia Time Zone 11
Australia/Melbourne AUS Eastern Standard Time
Asia/Irkutsk North Asia East Standard Time
America/Winnipeg Central Standard Time
Europe/Vatican W. Europe Standard Time
Asia/Amman Jordan Standard Time
Etc/UTC UTC
Asia/Tokyo Tokyo Standard Time
America/Toronto Eastern Standard Time
Asia/Singapore Singapore Standard Time
Australia/Lindeman E. Australia Standard Time
America/Los_Angeles Pacific Standard Time
Pacific/Majuro UTC+12
Pacific/Guadalcanal Central Pacific Standard Time
Europe/Athens GTB Standard Time
Europe/Monaco W. Europe Standard Time
>>>