sys-time-zone-info-transact-sql.md

title	sys.time_zone_info (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/27/2018
ms.prod	sql-non-specified
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.service
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
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
ms.workload	On Demand

sys.time_zone_info (Transact-SQL)

[!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.

See Also

GETUTCDATE (Transact-SQL)
AT TIME ZONE (Transact-SQL)
Date and Time Data Types and Functions (Transact-SQL)
Server-wide Configuration Catalog Views (Transact-SQL)