SELECT
root_user.*, chore.*, /*DATE_FORMAT(`user_birt`,'%d-%m-%Y')*/
DATE_FORMAT(`user_birt`,'%d-%m') AS fechac
FROM root_user, chore
WHERE root_user.chore_id=chore.chore_id
AND MONTH(STR_TO_DATE(user_birt, '%Y-%m-%d')) = MONTH(NOW())
AND user_stat = 'Activo'
AND chore.chore_id = 5 ORDER BY fechac ASC
SELECT
root_user.*, chore.*, /*DATE_FORMAT(`user_birt`,'%d-%m-%Y')*/
DATE_FORMAT(`user_birt`,'%d-%m') AS fechac
FROM root_user, chore
WHERE root_user.chore_id=chore.chore_id
AND MONTH(STR_TO_DATE(user_birt, '%Y-%m-%d')) = MONTH(NOW())
AND user_stat = 'Activo'
AND chore.chore_id = 5 ORDER BY fechac ASC 7678678678
Meteorologic System
Listado de Trabajadores de Cumpleaņos en Mes de Junio