Time Zone
timezone
A region of the globe that observes a uniform standard time for legal, commercial, and social purposes.
iana tzdb
The IANA Time Zone Database, commonly known as the tz database or Olson database, is maintained by the Internet Assigned Numbers Authority (IANA). It provides a comprehensive record of UTC offsets, daylight saving transition dates, and historical rule changes for every time zone in the world.
Time zones are identified using a "Region/City" format, such as Asia/Tokyo, America/New_York, and Europe/London. City names are used rather than country names because many countries span multiple time zones (e.g., the United States, Russia, and Australia). Approximately 600 zone identifiers are defined in the database.
The tz database is updated 3 to 10 times per year, with new releases issued whenever a country announces changes to its daylight saving rules or abolishes them entirely. Linux, macOS, Windows, Java, Python, and JavaScript (via the Intl API) all rely on this database for time conversions. Keeping systems up to date is essential for accurate results - running an outdated version can produce incorrect conversions for affected regions.
Was this article helpful?
timezone
A region of the globe that observes a uniform standard time for legal, commercial, and social purposes.
dst
The practice of advancing clocks by one hour during warmer months to extend evening daylight.
utc
The primary time standard by which the world regulates clocks and time, serving as the basis for civil timekeeping globally.
Building a timezone conversion API sounds simple but quickly hits IANA database management, DST gap handling, error semantics, and caching strategy. This article covers the design decisions that determine whether the endpoint stays reliable as policies and tzdata evolve.
Choosing between DATE, TIME, TIMESTAMP, and TIMESTAMPTZ shapes whether your application handles time zones correctly. This article walks through reservation systems, future event scheduling, audit trails, and migration strategy for legacy schemas that ignored time zones.
Learn how time zones divide the world into regions with different local times, how UTC offsets work, and why some zones use half-hour increments.