Answer the question
In order to leave comments, you need to log in
Date comparison and php notification?
Hello. There is a mysql database with full name and dates of birth.
Tell me the simplest script that will compare all dates and display the full name of those whose date of birth coincided with today's date?
Answer the question
In order to leave comments, you need to log in
stackoverflow.com/questions/2218378/use-mysql-to-d...
SELECT *
FROM USERS
WHERE
DATE_FORMAT(FROM_UNIXTIME(birthDate),'%m-%d') = DATE_FORMAT(NOW(),'%m-%d')
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question