Re: [BUGS] BUG #2366: Timestamptz data type is inaccurate

2006-03-31 Thread Tom Lane
"Christian Holtje" <[EMAIL PROTECTED]> writes: > 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

Re: [BUGS] BUG #2366: Timestamptz data type is inaccurate

2006-03-31 Thread Alvaro Herrera
Christian Holtje wrote: > 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) Times

[BUGS] BUG #2366: Timestamptz data type is inaccurate

2006-03-31 Thread Christian Holtje
The following bug has been logged online: Bug reference: 2366 Logged by: Christian Holtje Email address: [EMAIL PROTECTED] 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,