Re: BUG #5806: Julian Date routine miscalculates. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5806: Julian Date routine miscalculates.
Date
Msg-id 25538.1293645624@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5806: Julian Date routine miscalculates.  ("Leslie Satenstein" <lsatenstein@yahoo.com>)
List pgsql-bugs
"Leslie Satenstein" <lsatenstein@yahoo.com> writes:
> I tested and found the algorithm in Postgres to have the day before January
> 1,0001 calculating as December 31,0000 even though the world calculates the
> day before
> January 1,0001 as December 31,-0001.

As I already replied on the other list, this is not the case:

regression=# select '0001-01-01'::date - 1;
   ?column?
---------------
 0001-12-31 BC
(1 row)


            regards, tom lane

pgsql-bugs by date:

Previous
From: "Leslie Satenstein"
Date:
Subject: BUG #5806: Julian Date routine miscalculates.
Next
From: "Gabe Nell"
Date:
Subject: BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"