select
id,
DATE_FORMAT(birthday,"%Y-%m-%d") birthday,
CURDATE() ,
(year(CURDATE())-year(birthday)-1) + ( DATE_FORMAT(birthday, '%m%d') <= DATE_FORMAT(CURDATE(), '%m%d') ) as age
from
id,
DATE_FORMAT(birthday,"%Y-%m-%d") birthday,
CURDATE() ,
(year(CURDATE())-year(birthday)-1) + ( DATE_FORMAT(birthday, '%m%d') <= DATE_FORMAT(CURDATE(), '%m%d') ) as age
from
user ;
原文地址:http://houzhiqingjava.blog.163.com/blog/static/167399507201362084525866/