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.