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