how to sort "Day" on a Birthdate order by ASC?

[eluser]gRoberts[/eluser]

Code:

select * from table order by month(birthdate) asc #(order by numeric month value)

or

Code:

select * from table order by monthname(birthdate) asc #(order by month name value)