MySQL Date and Time Exercises: Calculate the age in year

MySQL Date Time: Exercise-6 with Solution

Write a query to calculate the age in year.

Code:

SELECT YEAR(CURRENT_TIMESTAMP) - 
         YEAR("1967-06-08") - 
             (RIGHT(CURRENT_TIMESTAMP, 5) < 
                  RIGHT("1967-06-08", 5)) as age;

Sample Output:

age
50

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to get the last day of the current year.
Next:Write a query to get the current date in the spacific format.