Zoneinfo

The zoneinfo database, also called the tz database, is a collaborative compilation of information about the world's time zones, primarily intended for use with computer programs and operating systems. [cite web |last=Eggert |first=Paul |coauthors= Olson, Arthur David |title= Sources for time zone and daylight saving time data |url=http://www.twinsun.com/tz/tz-link.htm |date=2007-11-29 |accessdate=2007-12-03 ] It is sometimes referred to as the Olson database after the founding contributor Arthur David Olson. [cite mailing list | last=Olson | first=Arthur David | date=1986-12-16 | title=Resolved timezone issue? Other issues. New ctime manual page | mailinglist=tz | url=mailto:[e-mail] ]

Its most recognizable feature is the uniform naming convention designed by Paul Eggert for time zones, such as “America/New_York” and “Europe/Paris”. [ cite mailing list | last=Eggert | first=Paul | title=proposal for time zone names | date=1993-10-20 | mailinglist=tz | url=mailto:[e-mail] ] The database attempts to record historical time zones and all civil changes since 1970, the Unix time epoch. [ cite mailing list | last=Olson | first=Arthur David | title=Re: ist of issues | date=1987-03-18 | mailinglist=tz | url=mailto:[e-mail] ] It also includes transitions such as daylight saving time, and even records leap seconds. [cite mailing list | last=Devine | first=Bob | title=leap seconds; [0-60] is ok | date=1988-06-02 | mailinglist=tz | url=mailto:[e-mail] ]

History

The project's origins go back to at least 1986. [cite mailing list | last=Olson | first=Arthur David | title=seismo!elsie!tz ; new versions of time zone stuff | date=1986-11-24 | mailinglist=tz | url=mailto:[e-mail] ] The project's database, as well as some reference source code, is in the public domain. [cite mailing list | last=Eggert | first=Paul | title=questions and comments on http://tycho.usno.navy.mil/tzones.html | date=1995-11-11 | mailinglist=tz | url=mailto:[e-mail] ] New editions of the database are published as changes warrant, usually several times per year. [ cite web | title=zoneinfo tzcode and tzdata archives (FTP) | url=ftp://munnari.oz.au/pub/oldtz/ | accessdate=2007-10-30 ]

Meaning of time zone

Within the zoneinfo database, a "time zone" is any national or sub-national region where local clocks have all agreed since 1970 [Theory (text file), contained in the "tzcode" distribution. Version tzcode2007h.tar.gz 2007-10-01 referenced.] .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 zoneinfo 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 zoneinfo database records the exact moment of transition between the variants. The format can accommodate changes in the dates and times of transitions as well.

Names of time zones

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 (encompasses both North and South), 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.

Country names are not used in this scheme, primarily because they would not be robustdue 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 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.

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.

File formats

The zoneinfo database is published as a set of text files, which lists 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().

Maintenance

The zoneinfo 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 elsie.nci.nih.gov and build the binary files themselves.

Use in software systems

The zoneinfo database is used for time zone processing and conversions in many computer software systems, including:

* BSD-derived systems, including FreeBSD, NetBSD, OpenBSD, DragonFly BSD, and Mac OS X;
* the GNU C Library and systems that use it, including GNU, most Linux distributions, BeOS, Nexenta OS, and Cygwin;
* the Java Runtime Environment since release 1.4 (2002);
* OpenVMS;
* Oracle releases since 10g (2004); [cite book | publisher=Oracle Corporation | title=Oracle Database Globalization Support Guide 10g Release 1 (10.1): Chapter 4, Section "Choosing a Time Zone File" | id=Part No. B10749-02 | month=June | year=2004 | pages=p. 4-14 | url=http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667 | accessdate=2007-10-30 ]
* PHP releases since 5.1.0 (2005);
* PostgreSQL since release 8.0 (2005);
* System V Release 4-derived systems, such as Solaris and UnixWare;
* AIX includes zoneinfo but does not use it itself, cite web |author= Wickremasinghe, Christopher |title= Introduction of daylight saving time in Western Australia 2006 |url=http://www-941.ibm.com/collaboration/wiki/x/IhI |date=2006-12-08 |accessdate=2008-03-18 |work= AIX Wiki |publisher=IBM] as it is for support of third-party applications like MySQL; [cite web |title= 2007 daylight savings time changes for Unix |url=http://www.uic.edu/depts/accc/systems/daylight/unix.html |date=2007-02-25 |accessdate=2008-03-18 |publisher= Academic Computing and Communications Center, University of Illinois at Chicago]
* several other Unix systems, including Tru64, and UNICOS/mp (also IRIX, still maintained but no longer shipped).

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. [cite web |url=http://unicode.org/cldr/data/diff/supplemental/windows_tzid.html |title= Windows → Tzid |date=2007-11-12 |accessdate=2008-02-17 |publisher= Unicode Consortium]

See also

* List of zoneinfo timezones
* Time zone
* Daylight saving time

Notes

References

* "tz mailing list"; archives of these messages are available at .

External links

* [http://www.twinsun.com/tz/tz-link.htm The zoneinfo home page]
* [http://news.gmane.org/gmane.comp.time.tz/ The tz mailing list archive]
* [ftp://elsie.nci.nih.gov/pub/ Current tz source and data files]
* [http://www.php.net/manual/en/timezones.php Lists of tz-zones by tz-group]
* [http://www.timdavis.com.au/2008/09/03/olson-time-zone-database-to-standard-windows-time-zone-v01/ Olson Database converted to Windows Standard Format]