sys.time_zone_info (Transact-SQL)sys.time_zone_info (Transact-SQL)

適用於:是SQL Server (從 2016 開始) 是Azure SQL Database 是Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server (starting with 2016) yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

傳回支援的時區資訊。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.KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones.

資料行名稱Column name 資料類型Data type 描述Description
namename sysnamesysname Windows 標準格式的時區名稱。Name of the time zone in Windows standard format. 比方說, cen。澳洲標準時間或是歐洲中部標準時間For example, Cen. Australia Standard Time or Central European Standard Time.
current_utc_offsetcurrent_utc_offset nvarchar(12)nvarchar(12) 目前的 UTC 的位移。Current offset to UTC. 例如, + 01:00或是 -07:00For example, +01:00 or -07:00.
is_currently_dstis_currently_dst bitbit 如果目前觀察日光節約時間,則為 true。True if currently observing daylight savings time.

另請參閱See Also

GETUTCDATE (Transact-SQL) GETUTCDATE (Transact-SQL)
AT TIME ZONE (Transact-SQL) AT TIME ZONE (Transact-SQL)
日期和時間資料類型與函式 (Transact-SQL) Date and Time Data Types and Functions (Transact-SQL)
伺服器範圍組態目錄檢視(Transact SQL)Server-wide Configuration Catalog Views (Transact-SQL)