BUG #2366: Timestamptz data type is inaccurate

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.

Responses

Browse pgsql-bugs by date

  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