Configure the time zone for SQL Server 2017 on Linux

Applies to: SQL Server - Linux

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

Overview

SQL Server 2017 (14.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 2017 (14.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.

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	E. Africa Standard Time
Africa/Kampala	E. Africa Standard Time
Africa/Khartoum	E. Africa 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	Greenwich 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	UTC
America/Dawson	Pacific 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/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	Pacific 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	Central Pacific Standard Time
Antarctica/Mawson	West Asia Standard Time
Antarctica/McMurdo	New Zealand Standard Time
Antarctica/Palmer	Pacific SA 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/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/Kolkatav	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/Gaza	West Bank Standard Time
Asia/Hebron	West Bank 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/Qyzylorda	Central Asia 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	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/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	Tonga Standard Time
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
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/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	Russian 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	Tonga Standard Time
Pacific/Fakaofo	Tonga Standard Time
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

Related content

• SQL Server on Linux
• Installation guidance for SQL Server on Linux
• Install the SQL Server command-line tools sqlcmd and bcp on Linux