Calculate Age in MySQL (InnoDb)

by

You can use TIMESTAMPDIFF(unit, datetime_expr1, datetime_expr2) function:

SELECT TIMESTAMPDIFF(YEAR, '1970-02-01', CURDATE()) AS age

Demo

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL – Rows to Columns
  3. ROW_NUMBER() in MySQL
  4. multiple query same table but in different columns mysql
  5. How can I make SQL case sensitive string comparison on MySQL?
  6. 1052: Column ‘id’ in field list is ambiguous
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. How to do a batch insert in MySQL
  9. Count the occurrences of DISTINCT values
  10. Search for “whole word match” in MySQL
  11. sql joins as venn diagram
  12. How can I join multiple SQL tables using the IDs?
  13. MySQL, better to insert NULL or empty string?
  14. SQL: selecting rows where column value changed from previous row
  15. Why do results from a SQL query not come back in the order I expect?
  16. How to generate data in MySQL?
  17. MySQL combine two columns and add into a new column
  18. SQL query of multiple values in one cell
  19. How to skip certain database tables with mysqldump?
  20. MySQL error 1241: Operand should contain 1 column(s)
  21. How to set a MySQL row to READ-ONLY?
  22. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  23. Mysql: Order by like?
  24. Getting first day of the week in MySql using Week No
  25. How to format number with “.” as thousands separator and “,” as decimal separator?
  26. Using DISTINCT and COUNT together in a MySQL Query
  27. INSERT INTO Table from multiple tables
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment