Re: Obtaining the Julian Day from a date

"Karl O. Pinc" <kop@meme.com> writes:
> Are there external representations of  BC dates?

Of course.

regression=# select to_char(date '4714-11-24 BC', 'J');
 to_char
---------
 0
(1 row)

            regards, tom lane