Skip to main content
Version: 24.3.x

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.