Find age SQL function

age1.sql

SELECT DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(dob, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(dob, '00-%m-%d')) AS age

age2.sql

SELECT name, dob, YEAR(CURRENT_DATE)
- YEAR(dob)
- CASE WHEN MONTH(CURRENT_DATE)
> MONTH(dob)
THEN 0
WHEN MONTH(CURRENT_DATE)
< MONTH(dob)
THEN 1
WHEN DAYOFMONTH(CURRENT_DATE)
< DAYOFMONTH(dob)
THEN 1
ELSE 0 END AS age
FROM people