sys.time_zone_info (Transact-SQL)
Applies to:
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
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)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za