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