Java MySQL 使用SQL语句,根据数据库生日字段计算用户年龄 使用SQL:ROUND(DATEDIFF(CURDATE(), 生日字段)/365.2422) as age进行计算 (当前日期2020-12-22) select 表名.*, ROUND(DATEDIFF(CURDATE(), birthday)/365.2422) as age from userinfo 结果: