MySQL timestampadd() 函数类似于 date_add()。
select timestampdiff(year,'2002-05-01','2001-01-01'); -- -1
select timestampdiff(day ,'2002-05-01','2001-01-01'); -- -485
select timestampdiff(hour,'2008-08-08 12:00:00','2008-08-08 00:00:00'); -- -12
SELECT * FROM t_admin WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) BETWEEN 10 AND 25;//得到10-25岁中间的人员资料
//得到10-25岁总人数
SELECT COUNT(1) FROM t_admin WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) BETWEEN 10 AND 25;
//得到25岁以上的人数
SELECT COUNT(1) FROM t_admin WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) > 25;