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

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
sys.time_zone_info (Transact-SQL)	sys.time_zone_info returns information about supported time zones.	rwestMSFT	randolphwest	11/25/2024	sql	system-objects	reference	sys.time_zone_info sys.time_zone_info_TSQL time_zone_info time_zone_info_TSQL	sys.time_zone_info system table	TSQL	=azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

sys.time_zone_info (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-asa-fabricse-fabricdw]

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.

Related content

• GETUTCDATE (Transact-SQL)
• AT TIME ZONE (Transact-SQL)
• Date and time data types and functions (Transact-SQL)
• Server-wide Configuration Catalog Views (Transact-SQL)