根据出生日期来计算年龄

DATE_FORMAT(
FROM_DAYS(
TO_DAYS(NOW()) - TO_DAYS(a.date_of_birth)
),
'%Y'
) + 0 AS age

原文地址:https://www.cnblogs.com/hwgok/p/6683511.html