mysql根据出生日期计算年龄

最新推荐文章于 2024-04-27 10:34:35 发布

原创最新推荐文章于 2024-04-27 10:34:35 发布 · 4.2k 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一种使用SQL从员工数据库中获取员工年龄、所在城市及所属分部名称的方法。通过结合FROM_DAYS和TO_DAYS函数计算年龄，并利用LEFT JOIN连接不同表以获取更全面的员工信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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