Re: Date and Time or Timestamp? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Date and Time or Timestamp?
Date
Msg-id 22481.1051717181@sss.pgh.pa.us
Whole thread Raw
In response to Re: Date and Time or Timestamp?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
Josh Berkus <josh@agliodbs.com> writes:
> And, on the up side, if the various *nixes fix their time zone behaviour past
> 2037, then Postgres will be automatically fixed as well, yes?

Depends what the new API looks like.  I would think that a sane answer
is to redefine time_t as a signed 64-bit value, preserving the 1/1/1970
zero origin, but who knows what the library people will really do?
glibc's recent move to redefine time_t as unsigned (losing support for
all pre-1970 dates) doesn't give me high confidence in their design
sensibility.

In any case you can bet that we'll have some work to do when a better
API is available.

            regards, tom lane


pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Date and Time or Timestamp?
Next
From: Mike Porter
Date:
Subject: ...