Time zones

The time zones database is maintained by the Internet Assigned Numbers Authority (IANA) and contains world UTC / Olson time zone codes and names including daylight saving time (DST).

Data structure

Field	Type	Description	Key
ISO	varchar(2)	ISO 3166-1 country code	PK
Country	varchar(45)	Country name
Olson	varchar(40)	Olson time zone name	PK
UTC	varchar(6)	UTC offset
DST	varchar(6)	Daylight saving time
Code	varchar(10)	Conventional time zone abbreviation
Name	nvarchar(50)	Conventional time zone name

Records: 403

Download

Reference data
Administrative divisions
Countries
Country names
Currencies
Languages
Postal code formats
Time zones

Formulas & samples
Distance between points
Locate points in a radius
Find postal code of a point

	English
	Español
	Français
	Italiano
	Português
Close