Edit

Share via

sys.time_zone_info (Transact-SQL)

  • Article

Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

sys.time_zone_info returns information about supported time zones.

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, +01:00 or -07:00.
is_currently_dst bit True if currently observing daylight savings time.

Remarks

All time zones installed on the computer are stored in the following registry hive:

  • KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones.

Permissions

Any user with CONNECT permissions can access this system catalog view.

Related content