On Fri, Jun 21, 2002 at 10:30:54 +0200,
Michael Agbaglo <byteshifter(at)shifted-bytes(dot)de> wrote:
>
> of course you could sort by DOY but then you'll have a problem w/ the
> next year:
>
> if it's let's say december and you select the list for the next 60 days,
> persons having birthday in december will appear after persons having
> birthday in january.
>
> I tried to use CASE WHEN... THEN in ORDER BY but it doesn't seem to work
> (syntax error at '')
You also need to worry about leap years. If a birthday is February 29
and there isn't one this year, what do you want to happen?