Re: BUG #2768: dates before year 1600 in timestamptz column give strange results - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2768: dates before year 1600 in timestamptz column give strange results
Date
Msg-id 16634.1164074290@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2768: dates before year 1600 in timestamptz column give strange results  ("Mikko Tiihonen" <mikko.tiihonen@iki.fi>)
Responses Re: BUG #2768: dates before year 1600 in timestamptz column give strange results
Re: BUG #2768: dates before year 1600 in timestamptz column
List pgsql-bugs
"Mikko Tiihonen" <mikko.tiihonen@iki.fi> writes:
> PostgreSQL compiled with intdatetime=off
>               stamp
> ----------------------------------
>  0134-05-06 08:52:26.123459+01:39
>  2134-05-06 09:12:34.123456+02
> (2 rows)

[ shrug... ]  Floating-point timestamps are not perfectly accurate; the
further away you go from 2000-01-01, the less so.  The weird offset from
GMT is probably a function of your local timezone, which you didn't
mention.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2767: Bug in avg(interval)
Next
From: Tom Lane
Date:
Subject: Re: BUG #2769: "invalid memory alloc request size " on startup