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
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