Query for Today's Month and Day

[oh_maestro]

I want to create a Happy Birthday query that will dynamically return names of people whose birthday is today. I want it to disregard the year however. So that people who were born 1/3/73 or 1/3/65 (or any year) would be returned Today (1/3/05).

The Field Name is BDay
The Table Name is Birthdays

Any ideas would be appreciated.

[eoghain]

SELECT name
  FROM Birthdays
 WHERE MONTH(CURRENT_DATE) = MONTH(BDay)
   AND DAYOFMONTH(CURRENT_DATE) = DAYOFMONTH(BDay)

Something like that should work, I just did something like this for my site. As long as that database you are using has the appropriate functions (this was for MySQL).

[oh_maestro]

It works!!!!

Thank you very much!