Syntax error How to calculate age in years from birthdate in MySQL?

How to calculate age in years from birthdate in MySQL?

We can calculate age in years from birthdate as follows −

mysql> SET @dob = '1984-01-17';
Query OK, 0 rows affected (0.00 sec)

This above query will pass the value’1984-01-17’ in the ‘dob’ variable. Then after applying the formula in the query below, we can get the age in years.

mysql> Select Date_format( From_Days( To_Days(Curdate()) - To_Days(@dob) ), '%Y' ) + 0 AS ‘Age in years;
+---------------+
| ‘Age in years’|
+---------------+
|   33          |
+---------------+
1 row in set (0.00 sec)
Updated on: 2020-01-28T10:08:56+05:30

361 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements