Peter Hicks wrote:
> I have the following SQL statement:
> SELECT * FROM members WHERE date_of_birth != '0000-00-
> 00' ORDER BY date_of_birth;
> date_of_birth is a DATE field, and I want to sort the results of the
> query on the month and day - to extract a list of birthdays
> throughout the year, in order, ignoring the year of birth.
> Can anyone help?
> Peter Hicks
I think you search for:
, MONTH( date_of_birth ) AS Month
, DAYOFMONTH( date_of_birth ) AS Day
date_of_birth != '0000-00-00'