几种方法：
select DATEDIFF(customer.dob, '2010-01-01') / 365.25 as ageSELECT DATE_FORMAT(FROM_DAYS(DATEDIFF(customer.dob,'2010-01-01')), ‘%Y’)+0 AS age
希望这对您有帮助
几种方法：
select DATEDIFF(customer.dob, '2010-01-01') / 365.25 as ageSELECT DATE_FORMAT(FROM_DAYS(DATEDIFF(customer.dob,'2010-01-01')), ‘%Y’)+0 AS age
希望这对您有帮助
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
