I need to look up and display the birthdays of the week on the system dashboard, but today a birthday boy is not showing up and would like to know where the error is.
Anniversary column: 1970-02-15 (date is saved this way in bd), type date and nullable .
Query mysql: SELECT * FROM tbl_usuarios WHERE (WEEK(Aniversario) = WEEK(now()))
We had not noticed anything wrong, until the birthday boy himself questioned us, now we are in doubt if the same should be happening with other users.