sys.time_zone_info#
Returns information about supported time zones.
On Windows, all time zones installed on the computer are stored in the following registry hive: KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones.
On Linux, usually the tzdata package is used to configure the system time zones. To list all available (OS-configured) time zones use the timedatectl command.
Column name |
Data type |
Description |
|---|---|---|
name |
sysname |
Name of the time zone in Windows standard format. For example, Cen. Australia Standard Time or Central European Standard Time. |
current_utc_offset |
nvarchar(12) |
Current offset to UTC. For example, +02:00 or -06:00. |
is_currently_dst |
bit |
True if currently observing daylight savings time. |