Configure time zone on SQL Server 2022 and later

• Linux

This article describes how to configure the time zone for SQL Server 2022 (16.x) and later

versions on Linux. You can also configure the time zone on Linux for

2017

and

Server 2019.

2022 (16.x) and later versions 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 on Linux first determines which time zone to use, using the first valid result

from the following sequence:

the

environment variable, if set;

the

symbolic link, if it exists;

the value

, if the file exists;

the

attribute from

, 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.

The Windows time zone is derived from the Linux

timezone using the following mapping.

Symbolic links in

and

are considered. For instance, if

is set to

and the

entry is a symbolic

link to

, the Windows time zone is resolved to

via the

mapping entry.

2022 CU 2 and later versions

2022 CU 1 and earlier versions

2022 CU 2 and later versions

TZ
/etc/localtime
/etc/timezone
ZONE=
/etc/sysconfig/clock