From: | "Christian Holtje" <christian(dot)holtje(at)timesys(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2366: Timestamptz data type is inaccurate |
Date: | 2006-03-31 16:38:49 |
Message-ID: | 200603311638.k2VGcnJR097341@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2366
Logged by: Christian Holtje
Email address: christian(dot)holtje(at)timesys(dot)com
PostgreSQL version: 7.4.8
Operating system: Ubuntu 5.10
Description: Timestamptz data type is inaccurate
Details:
I don't know what's going on, but basically, for some dates timestamptz is
loosing parts of the date/time (like the timezone, etc.)
db=# select '2076-03-30 19:57:05-05'::timestamptz;
timestamptz
---------------------
2076-03-31 00:57:05
(1 row)
db=# select '2037-03-30 19:57:05-05'::timestamptz;
timestamptz
------------------------
2037-03-30 20:57:05-04
(1 row)
db=# select '2006-03-30 19:57:05-05'::timestamptz + '100 years'::interval;
?column?
---------------------
2106-03-30 19:57:05
(1 row)
Note that the hours, minutes or timezone aren't correct. I tried the last
one to make sure it's not due to the parser.
Thanks for your help.
From | Date | Subject | |
---|---|---|---|
Next Message | Ed L. | 2006-03-31 17:16:56 | log xid with duration |
Previous Message | Bujic Nikola | 2006-03-31 09:19:58 | BUG #2365: can't install |