Re: how to sort a birthday list ?

On Fri, Jun 21, 2002 at 10:30:54 +0200, Michael Agbaglo <byteshifter@shifted-bytes.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?