Use MySQL to determine whether today is a user’s birthday

by

This should work:

   SELECT * 
      FROM USERS
      WHERE 
         DATE_FORMAT(FROM_UNIXTIME(birthDate),'%m-%d') = DATE_FORMAT(NOW(),'%m-%d')

More Related Contents:

  1. MySQL convert date string to Unix timestamp
  2. Should I use the datetime or timestamp data type in MySQL?
  3. How to get the difference between two timestamps in seconds
  4. Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?
  5. Timestamp with a millisecond precision: How to save them in MySQL
  6. Group mysql query by 15 min intervals
  7. How to select rows that have current day’s timestamp?
  8. MySql difference between two timestamps in days?
  9. Convert Unix timestamp into human readable date using MySQL
  10. MySQL CURRENT_TIMESTAMP on create and on update
  11. Calculating time difference between 2 dates in minutes
  12. When is a timestamp (auto) updated?
  13. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  14. How do I alter a mysql table column defaults?
  15. Xampp-mysql – “Table doesn’t exist in engine” #1932
  16. Unserialize through query at database level itself
  17. Detecting utf8 broken characters in MySQL
  18. How can I stop a MySQL query if it takes too long?
  19. MySQL throws Incorrect string value error
  20. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  21. Equivalent of MSSQL IDENTITY Column in MySQL
  22. #1060 – Duplicate column name ‘id’
  23. Count duplicates records in Mysql table?
  24. Update multiple rows with multiple ‘where’ clauses for each individual row
  25. ORDER BY alphabet first then follow by number
  26. django cannot connect mysql in docker-compose
  27. WHERE datetime older than some time (eg. 15 minutes)
  28. mysql create table dynamically
  29. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?
  30. Errno 121, duplicate key on write or update?

Leave a Comment