Events
31 Mar, 23 - 2 Apr, 23
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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. |
All time zones installed on the computer are stored in the following registry hive:
KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones
.Any user with CONNECT
permissions can access this system catalog view.
Events
31 Mar, 23 - 2 Apr, 23
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register today