Postgres Pro
Downloads
Home   >   mailing lists

Re: Obtaining the Julian Day from a date - Mailing list pgsql-general

From Tom Lane
Subject Re: Obtaining the Julian Day from a date
Date
Msg-id 22342.1094928882@sss.pgh.pa.us
Whole thread Raw
In response to Re: Obtaining the Julian Day from a date  ("Karl O. Pinc" <kop@meme.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Obtaining the Julian Day from a date
Next
From: Dan Sugalski
Date:
Subject: Re: Speeding up LIKE with placeholders?