Re: Obtaining the Julian Day from a date

On 2004.09.10 20:32 Bruno Wolff III wrote:

> If you keep your data in a date field you can get the Julian day
> by subtracting the appropiate date. You can then do mod on this
> difference.

I've been doing:

CAST (to_char(date, 'J') AS INT)

but your way seems faster.  Is it?

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein