mysql 对日期加减天数
1.日期加一天
select date_add('2021-05-01', interval +1 day) as result
select date_add('2021-05-31', interval +1 day) as result
案例2:日期减一天
select date_add('2021-05-01', interval -1 day) as result
select date_add('2021-05-31', interval -1 day) as result
发布于 2021-05-19 16:00