mysql根据出生日期计算年龄

coolt

于 2013-10-10 10:35:27 发布

阅读量4.1k

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/kimnwang/article/details/12559183

版权

mysql 专栏收录该内容

4 篇文章

订阅专栏

DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(BirthDate)) ,'%Y') +0 AS Age

SELECT a.*,DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(BirthDate)) ,'%Y') +0 AS Age,b.City,c.Name
FROM `employee_master` AS a
LEFT JOIN `city_master` AS b ON(a.CtyID=b.CityID)
LEFT JOIN `branch_master` AS c ON(a.BrnID=c.BrnID) WHERE 1=1

SELECT a.*,DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(BirthDate)) ,'%Y') +0 AS Age,b.City,c.Name
FROM  `employee_master` AS a 
LEFT JOIN `city_master` AS b ON(a.CtyID=b.CityID) 
LEFT JOIN `branch_master` AS c ON(a.BrnID=c.BrnID) WHERE 1=1