I am trying to pull in birthdays coming up in the next 60 days but am not quite sure how to get it to ignore the year and just compare month and day. Any help would be greatly appreciated.
SELECT
CONCAT(emp_fname,' ',emp_lname) AS emp_name,
DATE_FORMAT(emp_dob, '%W, %M %D') AS birthday
FROM
Employee
WHERE
emp_dob >= CURDATE()
AND emp_dob <= DATE_ADD(CURDATE(), INTERVAL 60 DAY)
ORDER BY
emp_dob ASC
Tried this as well... No workie...
SELECT
CONCAT(emp_fname,' ',emp_lname) AS emp_name,
DATE_FORMAT(emp_dob, '%W, %M %D') AS birthday
FROM
Employee
WHERE
DATE_FORMAT(emp_dob, '%m-%d') BETWEEN DATE_FORMAT(CURDATE(), '%m-%d') AND DATE_ADD(DATE_FORMAT(CURDATE(), '%m-%d'), INTERVAL 30 DAY)
ORDER BY
emp_dob ASC