-- 获取多少天之前的日期
select DATE_SUB( curdate( ), INTERVAL 60 YEAR ) -- 1960-08-21
select DATE_SUB( curdate( ), INTERVAL 60 MONTH) -- 2015-08-21
select DATE_SUB( curdate( ), INTERVAL 60 DAY) -- 2020-06-22
-- 获取两个时间之间相差多少天
select TIMESTAMPDIFF( DAY, '1961-08-21', DATE_SUB( curdate( ), INTERVAL 60 YEAR ) ) -- -365
select TIMESTAMPDIFF( DAY, '1999-08-21', DATE_SUB( curdate( ), INTERVAL 60 YEAR ) ) -- -14244