Get Time Zone Information in SQL Server

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;