Re: Redhat 7.3 time manipulation bug - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Redhat 7.3 time manipulation bug
Date
Msg-id 3CEE3BCF.9F06A16F@fourpalms.org
Whole thread Raw
In response to Re: Redhat 7.3 time manipulation bug  (Trond Eivind Glomsrød <teg@redhat.com>)
Responses Re: Redhat 7.3 time manipulation bug  (cbbrowne@cbbrowne.com)
List pgsql-hackers
...
> But anybody using Unix dates as "general dates" has leaped into exactly the
> same sort of trap that caused people to get so paranoid about Y2K.

Certainly true. We don't use Unix dates as "general dates", we use the
Unix time zone database and API for dates and times within the year
range of 1903 to 2038. Well, up until now anyway...

Prior to the 1900s, the concept of time zones was more localized and not
universally adopted. In the US, a first round of time zone
standardization came with the transcontinental railroads in the 1860s.
After 2038, it is a good bet that time zones will resemble those in use
today, but they are as much a political construct as a physical one so
the details are subject to change.
                     - Thomas


pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: Redhat 7.3 time manipulation bug
Next
From: cbbrowne@cbbrowne.com
Date:
Subject: Re: Redhat 7.3 time manipulation bug