Thread: Unix 2038 And PostgreSQL

Unix 2038 And PostgreSQL

From
Sai Hertz And Control Systems
Date:
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