"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
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
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,