mysql 关于日期比较相关函数(自用,不喜勿喷)

    select * from retire_infor re
where (YEAR(NOW())-YEAR(birtyday)) BETWEEN 71 AND 80
and  re.`status`='6';


SELECT DATEDIFF(NOW(),'2017-09-01') AS DiffDate;


SELECT DATEDIFF(CURDATE(), '2016-01-13')/365.2422;//不满一年会加1

select TIMESTAMPDIFF(YEAR, '2016-11-13', CURDATE());//不满一年为0

   参考链接:http://www.jianshu.com/p/64b53c26bea1