U
U
unlik2017-04-12 21:14:54
PHP
unlik, 2017-04-12 21:14:54

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

1 answer(s)
A
Andrey Burov, 2017-04-12
@BuriK666

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 question

Ask a Question

731 491 924 answers to any question