Postgres Pro
Downloads
Home   >   mailing lists

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

From Phil Endecott
Subject Re: Obtaining the Julian Day from a date
Date
Msg-id 4140960E.20403@chezphil.org
Whole thread Raw
In response to Obtaining the Julian Day from a date  ("Karl O. Pinc" <kop@meme.com>)
List pgsql-general
Tree view 
Karl O. Pinc wrote:
> What's the best way to obtain the Julian day from a postgresql
> date?

=> select to_char('17 may 1970'::date,'J');
  to_char
---------
  2440724


--Phil.

pgsql-general by date:

Previous
From: Wes
Date:
Subject: Re: How to determine a database is intact?
Next
From: Edwin Grubbs
Date:
Subject: referential integrity preventing simultaneous insert