se il campo è datetime
codice:
SELECT MONTH(birthdate) AS month, DAY(birthdate) AS day FROM tabella