title: "sys.time_zone_info (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/27/2018" ms.prod: sql ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" applies_to:
- "Azure SQL Database"
- "SQL Data Warehouse"
- "SQL Server (starting with 2016)" f1_keywords:
- "sys.time_zone_info"
- "sys.time_zone_info_TSQL"
- "time_zone_info"
- "time_zone_info_TSQL" helpviewer_keywords:
- "sys.time_zone_info system table" ms.assetid: 3f51a9a4-75f8-4a11-9552-8bf6118b68da caps.latest.revision: 7 author: edmacauley ms.author: edmaca manager: craigg monikerRange: "= azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2014-asdb-xxxx-xxx-md]
Returns information about supported time zones. All time zones installed on the computer are stored in the following registry hive:
KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\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. |
GETUTCDATE (Transact-SQL)
AT TIME ZONE (Transact-SQL)
Date and Time Data Types and Functions (Transact-SQL)
Server-wide Configuration Catalog Views (Transact-SQL)