1.减函数DATE_SUB
--date_sub
select
DATE_SUB('2021-12-17',INTERVAL 1 DAY) as dayTime,--昨天
DATE_SUB('2021-12-17',INTERVAL 1 MONTH) as monthTime,--上个月
DATE_SUB('2021-12-17',INTERVAL 1 YEAR) as yearTime;--去年
2.DATEDIFF
--DATEDIFF(newDate,oldDate)
SELECT DATEDIFF('2021-12-19','2021-12-18') as value1,
DATEDIFF('2021-12-18','2021-12-19') AS value2;