Re: [HACKERS] Postgres - Y2K Compliant....Yes or No

On Mon, 19 Oct 1998, D'Arcy J.M. Cain wrote:

> Thus spake Chris Williams
> > I have seen other postings about Y2K compliance of postgres but no answers. Can anyone tell me how
> > compliant Postgres is?
>
> darcy=> select 'NOW'::timestamp;
> ?column?
> ----------------------
> 1998-10-19 17:45:27-04
> (1 row)
>
> Now 2038 compliance is another matter. :-)
>
> P.S. I'm sure we'll have 8 byte times by then.

2038 is for 31 bit (signed int) times, if we simply go to a unsigned int
that will extend things for another 68 years, and break very few things.
By 2106, I'm sure we'll have something better to do.

> --
> D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
> http://www.druid.net/darcy/ | and a sheep voting on
> +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.

Tom