Re: More time zones - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: More time zones
Date
Msg-id Pine.LNX.4.30.0202252149380.836-100000@peter.localdomain
Whole thread Raw
In response to Re: More time zones  (Thomas Lockhart <lockhart@fourpalms.org>)
Responses Re: More time zones  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Thomas Lockhart writes:

> > I claim that most of the time zone abbreviations that we have now are
> > purely theoretical fabrications.
>
> Hmm. How would you arrive at that conclusion?

Some of the entries are obviously bogus, for example BRA "Brazil Time",
although Brazil has three time zones.  Also, there are only half a dozen
or so countries in the world that have more than one time zone, and quite
a few countries don't speak English, so it seems unlikely that in a place
like that a common-usage English-language time zone designation would
evolve.  So for instance, FWT "French Winter Time" is highly unlikely to
be in actual use.

> Most of the existing entries appear in the zinc database and in other
> references, and I'll assume that most of the places which these
> correspond to actually exist.

The tz database contains this note:

"""
Alphabetic time zone abbreviations should not be used as unique
identifiers for UTC offsets as they are ambiguous in practice. For
example, "EST" denotes 5 hours behind UTC in English-speaking North
America, but it denotes 10 or 11 hours ahead of UTC in Australia; and
French-speaking North Americans prefer "HNE" to "EST". For compatibility
with POSIX the tz database contains English abbreviations for all time
stamps but in many cases these are merely inventions of the database
maintainers.
"""

So what this means is that the tz database (which I assume is the same as
the zinc you speak of) merely assigns some string to each distinct set of
rules so that POSIX systems have something to put into their tzname
variable.

One concern I have about the time zone abbreviation database is that the
inflation of possible choices makes any kind of error checking mostly
non-existant.  And who is going to remember all the abbreviations anyway,
even if they were documented?

I think we should scrap about 90% of the time zone names we have in there
unless there's evidence of actual use.  Instead, it would be preferrable
to use numerical offsets, or if some geographical association is desired,
the Continent/City syntax.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: More time zones
Next
From: "Arguile"
Date:
Subject: Timezone Inconsistancies