Re: [GENERAL] Obtaining the Julian Day from a date

2004-09-10 Thread Bruno Wolff III
On Thu, Sep 09, 2004 at 16:32:18 -0500, "Karl O. Pinc" <[EMAIL PROTECTED]> wrote: > > Unfortunately modulo (%) does not operate on dates so I still need > > to convert to Julian day. :-( I need to know where I am within a > regular repeating interval. Mostly, in my case, modulo 2. > (We arbi

[GENERAL] Obtaining the Julian Day from a date

2004-09-09 Thread Karl O. Pinc
Hi, What's the best way to obtain the Julian day from a postgresql date? PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) I'm doing some date arithmetic with 1 day intervals and want to, for example, round to the even Ju