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
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 |
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 |