Skip to main content

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],
    current_utc_offset,
    is_currently_dst
from sys.time_zone_info
order by [name];