Re: BUG #5806: Julian Date routine miscalculates.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Leslie Satenstein" <lsatenstein(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5806: Julian Date routine miscalculates.
Date: 2010-12-29 18:00:24
Message-ID: 25538.1293645624@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Leslie Satenstein" <lsatenstein(at)yahoo(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Gabe Nell 2010-12-29 19:09:14 BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"
Previous Message Leslie Satenstein 2010-12-29 17:49:34 BUG #5806: Julian Date routine miscalculates.