Get difference in years between two dates in MySQL as an integer

by

For anyone who comes across this:

another way this can be done is:

SELECT TIMESTAMPDIFF(YEAR, date_of_birth, CURDATE()) AS difference FROM student

For differences in months, replace YEAR with MONTH, and for days replace YEAR with DAY

Hope that helps!

More Related Contents:

  1. SQL split values to multiple rows
  2. How do I escape reserved words used as column names? MySQL/Create Table
  3. How to store multiple options in a single table?
  4. How to populate a table with a range of dates?
  5. Get the new record primary key ID from MySQL insert query?
  6. What is the opposite of GROUP_CONCAT in MySQL?
  7. How to Perform an UPSERT so that I can use both new and old values in update part
  8. brew install mysql on macOS
  9. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  10. MySQL: selecting rows where a column is null
  11. How do I check to see if a value is an integer in MySQL?
  12. Convert timestamp to date in MySQL query
  13. Update a column value, replacing part of a string
  14. Store image to database blob; retrieve from db into Picturebox
  15. MySQL trigger On Insert/Update events
  16. MySQL combine two columns into one column
  17. MySQL Insert Into from one Database in another
  18. How can I change MariaDB to MySQL in XAMPP?
  19. MySQL: LIMIT by a percentage of the amount of records?
  20. How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]
  21. MySQL multiple columns in IN clause
  22. MySQL Stored Procedures not working with SELECT (basic question)
  23. Sum results of a few queries and then find top 5 in SQL
  24. ERROR 1148: The used command is not allowed with this MySQL version
  25. Too many auto increments with ON DUPLICATE KEY UPDATE
  26. MySQL OPTIMIZE all tables?
  27. What’s mysql’s “BETWEEN” performance over..?
  28. Deleting a row based on the max value
  29. mysql double-quoted table names
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment