How to Calculate Age From Date of Birth Using MySQL?

In this tutorial, we will learn how to calculate age from date of birth using MySQL.

We can calculate age from date of birth using PHP, Laravel, CodeIgniter, etc. but in this we focus on how to calculate age using SQL Server’s DATEDIFF() function.

Syntax

DATEDIFF(interval, date1, date2)

Example

SELECT 
    Id,
    FLOOR(DATEDIFF(CURDATE(), STR_TO_DATE(born_date, '%Y-%m-%d')) / 365) AS age 
FROM 
    `users`;

Conclusion

Age can be calculated from a date of birth in MySQL using the DATEDIFF() function with FLOOR() and STR_TO_DATE() to correctly determine age without storing it in the database.