SelectDate_format(From_Days(To_Days(Curdate())-To_Days(@dob)),'%Y')+"/> SelectDate_format(From_Days(To_Days(Curdate())-To_Days(@dob)),'%Y')+">

Home >Database >Mysql Tutorial >How to calculate age from date of birth in MySQL?

How to calculate age from date of birth in MySQL?

PHPz
PHPzforward
2023-09-18 16:21:082255browse

How to calculate age from date of birth in MySQL?

We can calculate the age from date of birth as follows -

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

The 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)

The above is the detailed content of How to calculate age from date of birth in MySQL?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete