On this page

    SYS.TIMEZONE_NAMES

    The sys.timezone_names table contains a complete list of timezones and associated information.

    Syntax
    SELECT * 
    FROM sys.timezone_names
    

    Example Output

    note:

    This is a random sampling of the sys.timezone_names table. The table contains a compelete list of timezones.

    timezone_nametz_offsetoffset_daylight_savingsis_daylight_savings
    Africa/Kampala+03:00+03:00false
    America/Belize-06:00-06:00false
    America/Goose_Bay-04:00-03:00true
    America/Los_Angeles-08:00-07:00true
    America/New_York-05:00-04:00true
    Antarctica/South_Pole+12:00+12:00false
    Asia/Macau+08:00+08:00false
    Europe/Berlin+01:00+02:00true
    US/Hawaii-10:00-10:00false
    US/Pacific-08:00-07:00true
    UTC+00:00+00:00false
    Universal+00:00+00:00false

    Fields

    FieldData TypeDescription
    timezone_namevarcharThe name of the timezone.
    tz_offsetvarcharThe offset for the timezone.
    offset_daylight_savingsvarcharThe offset for the timezone during Daylight Savings time.
    is_daylight_savingsbooleantrue if the timezone honors daylight savings; false otherwise.