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

title	sys.time_zone_info (Transact-SQL) | Microsoft Docs
ms.custom	SQL2016_New_Updated
ms.date	09/12/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
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	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.time_zone_info (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-all-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)