Επεξεργασία

Κοινή χρήση μέσω


Configure the time zone for SQL Server 2022 on Linux

Applies to: SQL Server - Linux

This article describes how to configure the time zone for SQL Server 2022 (16.x) on Linux. You can also configure the time zone on Linux for SQL Server 2017 and SQL Server 2019.

Overview

SQL Server 2022 (16.x) on Linux uses Windows time zones internally. All Transact-SQL (T-SQL) commands use Windows time zones, for example the CURRENT_TIMEZONE_ID function and AT TIME ZONE query operator.

  1. SQL Server 2022 (16.x) on Linux first determines which time zone to use, using the first valid result from the following sequence:

    • the TZ environment variable, if set;
    • the /etc/localtime symbolic link, if it exists;
    • the value /etc/timezone, if the file exists;
    • the ZONE= attribute from /etc/sysconfig/clock, if they exist.
  2. The resulting Linux time zone is then mapped to a corresponding Windows time zone via a fixed Time zone mapping table.

Time zone mapping

The Windows time zone is derived from the Linux tz timezone using the following mapping.

Symbolic links in /usr/share/zoneinfo and /usr/lib/zoneinfo are considered. For instance, if TZ is set to America/Knox_IN and the /usr/share/zoneinfo/America/Knox_IN entry is a symbolic link to /usr/share/zoneinfo/America/Indiana/Knox, the Windows time zone is resolved to Central Standard Time via the America/Indiana/Knox mapping entry.

SQL Server 2022 CU 2 and later versions

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

SQL Server 2022 CU 1 and earlier versions

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