Get a list of supported Time Zones in SQL Server and Azure SQL Database

Updated: Dec 31, 2021

Do you want to find out supported time zones in SQL Server and Azure SQL Database? If yes, get the query in this article.


The sys.time_zone_info returns supported time zones in SQL Server.


SELECT *
FROM sys.time_zone_info

The above query returns 141 timezone, their UTC offset, and a column to check if the timezone has daylight savings time.



TimeZone in SQL Server


4 views0 comments