Return information about supported time zones in SQL Server. All time zones installed on the computer are stored in the following registry hive:
select [name] time_zone_name,
current_utc_offset,
is_currently_dst
from sys.time_zone_info
order by current_utc_offset;