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

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.