The tz database, also called the zoneinfo database, is a collaborative compilation of information about the world's time zones, primarily intended for use with computer programs and operating systems.[1] It is sometimes referred to as the Olson database after the founding contributor Arthur David Olson.[2] Paul Eggert is editor and maintainer of the tz database.[3]
Its most recognizable feature is the uniform naming convention designed by Paul Eggert for time zones, such as “America/New_York” and “Europe/Paris”.[4] The database attempts to record historical time zones and all civil changes since 1970, the Unix time epoch.[5] It also includes transitions such as daylight saving time, and even records leap seconds.[6]
Contents |
The project's origins go back to at least 1986.[8] The project's database, as well as some reference source code, is in the public domain.[9] New editions of the database are published as changes warrant, usually several times per year.[10]
Within the tz database, a time zone is any national or sub-national region where local clocks have all agreed since 1970.[11] This definition concerns itself first with geographic areas which have had consistent local clocks. This is different from other definitions which concern themselves with consistent offsets from a prime meridian. Therefore each of the time zones defined by the tz database may document multiple offsets (relative to UTC); typically containing both the standard time and the daylight saving time in the same zone. Sometimes the number of different offsets may be larger, depending on the history of the region.
For each time zone that has multiple offsets, usually the standard and daylight variants, the tz database records the exact moment of transition between the variants. The format can accommodate changes in the dates and times of transitions as well.
The file zone.tab is in the public domain. Columns and row sorting are described in the comments of the file, as follows
# This file contains a table with the following columns: # 1. ISO 3166 2-character country code. See the file `iso3166.tab'. # 2. Latitude and longitude of the zone's principal location # in ISO 6709 sign-degrees-minutes-seconds format, # either +-DDMM+-DDDMM or +-DDMMSS+-DDDMMSS, # first latitude (+ is north), then longitude (+ is east). # 3. Zone name used in value of TZ environment variable. # 4. Comments; present if and only if the country has multiple rows. # # Columns are separated by a single tab. # The table is sorted first by country, then an order within the country that # (1) makes some geographical sense, and # (2) puts the most populous zones first, where that does not contradict (1).
The time zones in the database are given uniform names, such as “America/New_York”, in an attempt to make them easier to understand by humans and to remove ambiguity.
These names are all of the form Area/Location, where Area is the name of a continent or ocean, and Location is the name of a specific location within that region, usually cities or small islands. The set of areas currently includes: Africa, America, Antarctica, Arctic, Asia, Atlantic, Australia, Europe, Indian, and Pacific.
Additionally a special area of Etc is used for some administrative zones, particularly for “Etc/UTC” which represents Coordinated Universal Time. In order to conform with the POSIX style, those zones beginning with "Etc/GMT" have their sign reversed from what most people expect. In this style, zones west of GMT have a positive sign and those east have a negative sign.
Country names are not used in this scheme, primarily because they would not be robust due to frequent political and boundary changes. The names of large cities tend to be more permanent. However, the database maintainers attempt to include at least one zone for every ISO 3166-1 alpha-2 country code, and a number of user interfaces to the database take advantage of this. Additionally there is a desire to keep locations geographically compact so that any future time zone changes do not split locations into different time zones.[citation needed]
A choice was also made to use English names or equivalents, and to omit punctuation and common suffixes. The underscore character is used in place of spaces. Usually the most populous city in a region is chosen to represent the entire time zone, although other cities may be selected if they are more widely known or result in a less ambiguous name. In the event that the name of a city changes, the convention is to create an alias in future editions so that both the old and new names refer to the same database entry.
In a few rare cases the Location is itself represented as a compound name, for example the time zone “America/Indiana/Indianapolis”. The only three-level names currently include those under “America/Argentina/…”, “America/Kentucky/…”, “America/Indiana/…”, and “America/North_Dakota/…”.
The location selected is representative for the entire area, so not every city has a time zone named after it. There is for example no “America/Boston” time zone. Furthermore, different places which currently conform to the same time zone may have different names if historically they differed or are within different countries.
Data before 1970 aims to be correct for the city identifying the region, but is not necessarily correct for the entire region. This is because new regions are created only as required to distinguish clocks since 1970.
For example, between 1963-10-23 and 1963-12-09 in Brazil only Minas Gerais, Espirito Santo, Rio de Janeiro and Sao Paulo had summer time, but on request a split from America/Sao_Paulo was rejected with the reasoning that since 1970 the clocks were the same in the whole region.[12]
The tz database is published as a set of text files which list the rules and zone transitions in a human-readable format. For use, these text files are compiled into a set of platform-independent binary files—one per time zone. The reference source code includes such a compiler called zic (zone information compiler), as well as code to read those files and use them in standard APIs such as localtime() and mktime().
The tz reference code and database is maintained by a group of volunteers. Arthur David Olson makes most of the changes to the code, and Paul Eggert to the database. Proposed changes are sent to the tz mailing list, which is gatewayed to the comp.time.tz newsgroup. Source files are distributed via the FTP server elsie.nci.nih.gov. Typically, these files are taken by a software distributor like Debian, compiled, and then the source and binaries are packaged as part of that distribution. End users can either rely on their software distribution's update procedures, which may entail some delay, or obtain the source directly from ftp://elsie.nci.nih.gov/pub/ and build the binary files themselves.
The tz database is used for time zone processing and conversions in many computer software systems, including:
The Olson timezone IDs are also used by the Unicode Common Locale Data Repository (CLDR). For example, the CLDR Windows → Tzid table maps Microsoft Windows time zone IDs to the standard Olson names.[16]
|
|||||||||||
|
|
Top topics
Wikis
Search
