Mysql/Java根据出生日期计算年龄

最新推荐文章于 2024-07-26 17:08:18 发布

thinktech_Li

最新推荐文章于 2024-07-26 17:08:18 发布

阅读量900

点赞数 1

分类专栏：数据库

本文链接：https://blog.csdn.net/Tenlay_Li/article/details/81479811

版权

数据库专栏收录该内容

8 篇文章 1 订阅

订阅专栏

Mysql 根据出生日期计算年龄
1.DATEDIFF()计算天数差，一年365天5小时48分46秒（365.2422天），FLOOR()向下取整
SELECT name,birth,FLOOR(DATEDIFF(CURDATE(),birth)/365.2422) AS age FROM sys_user
  
2.DATEDIFF()计算天数差，FROM_DAYS()将天数转换为日期格式
SELECT name,birth,YEAR(FROM_DAYS(DATEDIFF(CURDATE(),birth))) AS age FROM sys_user
  
3.看着稍微复杂点，仔细看就是当前日期年相差，月份比较
SELECT name,birth,
(YEAR(CURDATE())-YEAR(birth)-1) + (DATE_FORMAT(birth,'%m%d') <= DATE_FORMAT(CURDATE(),'%m%d')) AS age
FROM sys_user

比较年比较月份，可以得到几周岁又几个月

SELECT name,CONCAT(age1, month1) age FROM (
SELECT name,CONCAT(TIMESTAMPDIFF(YEAR,entry_date,CURDATE()),"周岁") as age1,
			CONCAT(MOD(TIMESTAMPDIFF(MONTH,entry_date,CURDATE()),12),"月") as month1 
FROM sys_contract WHERE id = '1' 
) as a

  
4.TIMESTAMPDIFF()函数，这个是目前最精简的
SELECT name,birth,TIMESTAMPDIFF(YEAR,birth,CURDATE()) AS age FROM sys_user

Java 根据出生日期计算年龄
/**
 * 根据出生年月计算年龄
 * @param birth
 * @return age
 */
public static String getAgeByBirth(String birth){
   if ("".equals(birth.trim()) || birth.trim() == null) {
      return null;
   }
   //此处调用了获取当前日期，以yyyy-MM-dd格式返回的日期字符串方法
   String nowDate = DateUtils.getDate();
   int age = Integer.parseInt(nowDate.substring(0, 4))- Integer.parseInt(birth.substring(0,4));
   return Integer.toString(age);
}