Re: Time zone abbreviations and calendars

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Time zone abbreviations and calendars
Date: 2003-03-07 15:33:26
Message-ID: 418.1047051206@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Considering the time zone abbreviations that are accepted on input, I find
> a couple of bogosities:

Presumably we can get some local knowledge on those items from list
members. I believe that Thomas created the TZ tables on the basis of
including everything he could find mentioned in the zic database, so
there very probably are some entries in there that are not in current
use. I don't see any need to remove such entries, unless they actively
conflict with more-current usage.

> I also have some doubts about the terminology offered in the "History of
> Units" section. It says
> Julian day = invented by Scaliger, counts days from 1 January 4713 BC
> Julian date = invented by Caesar, predecessor of modern calendar
> However, my sources say that the first is the "Julian date" and the second
> is simply the Julian calendar. Ideas?

I believe you are correct on both points.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-03-07 15:38:19 Re: Updateable views...
Previous Message mlw 2003-03-07 15:23:28 Re: talking to postgresql from C/C++