Unix 2038 And PostgreSQL

From: Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Unix 2038 And PostgreSQL
Date: 2003-12-22 15:58:23
Message-ID: 3FE7149F.5030508@sancharnet.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Dear all,

Before reading all this let me assure you nothing is out of control just
DONT PANIC!!!!

I was just going through the pages of http://www.2038.org
and was concerned by the fact my computer using Linux will rollover to

Fri Dec 13 20:45:52 1901

after

Tue Jan 19 03:14:07 2038

Now this was very serious for me as my clients use big dates for work
though my linux system indicated it would be effected by 2038 (Run the
perl script available on that site)

but a quick

select date'2038-01-19' + 1;
gave me result

2038-01-20
Now that was what I looking for
I believe that PostgreSQL guys have worked around the 2038 problem

any suggestions and further finding's are most welcome.

My Systems Config is ,
PostgreSQL 7.3.4
RH 9.0

Regards,
Vishal Kashyap.

Related Links ...
http://news.com.com/2100-7355-5129875.html
http://www.unix-systems.org/version2/whatsnew/year2000.html
http://www.UNIX-systems.org/go/unix <http://www.unix-systems.org/go/unix>.
http://developers.slashdot.org/developers/03/12/21/1952207.shtml?tid=126&tid=128&tid=156

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2003-12-22 17:26:18 constaint addition to existing schema
Previous Message Tom Lane 2003-12-22 15:21:09 Re: Opinion wanted: Default select rights for users via public schema

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-22 16:02:15 Re: MySQL Gets Functions in Java - Enlightenment Please
Previous Message Robert Treat 2003-12-22 15:42:12 Re: Tables Referencing themselves As Foreign Keys