How to get an age from a D.O.B field in MySQL?

by 
SELECT DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(dob, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(dob, '00-%m-%d')) AS age

More Related Contents:

  1. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  2. MySQL Query – Records between Today and Last 30 Days
  3. Select mysql query between date?
  4. How do I get the first day of the week of a date in mysql?
  5. Compare only day and month with date field in mysql
  6. What is better subquery vs literal on IN clause in mysql
  7. SQL query return data from multiple tables
  8. Get a list of dates between two dates
  9. MySQL SELECT only not null values
  10. Difference between two dates in MySQL
  11. How do I select between the 1st day of the current month and current day in MySQL?
  12. MySQL SELECT increment counter
  13. MySQL select with CONCAT condition
  14. mysql: get record count between two date-time
  15. How to get first day of every corresponding month in mysql?
  16. How does MySQL’s ORDER BY RAND() work?
  17. MySQL INSERT INTO … VALUES and SELECT
  18. Mysql select distinct
  19. How to select one row randomly taking into account a weight?
  20. MySQL INNER JOIN select only one row from second table
  21. How to select only date from a DATETIME field in MySQL?
  22. Insert/ Update random date in MySQL
  23. What is the default MySQL JOIN behaviour, INNER or OUTER?
  24. MySQL : retrieve a large select by chunks
  25. MySQL – insert data from another table merged with constants
  26. How to compare timestamp dates with date-only parameter in MySQL?
  27. Insert data into table with result from another select query
  28. How to SELECT by MAX(date)?
  29. How to use Table output from stored MYSQL Procedure
  30. MySQL Select Multiple VALUES

Leave a Comment