mysql 根据出生日期计算年龄

TIMESTAMPDIFF(YEAR, `r`.`brithdate`, CURDATE()) AS 'age'

 

 CONCAT(TIMESTAMPDIFF(YEAR, r.brithdate, CURDATE()),'岁',(r.brithdate mod 12 ),'个月') AS 'age'