| 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: | Whole Thread | Raw Message | 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 |