sys.time_zone_info (Transact-SQL)
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.