首发于 mysql

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

文章被以下专栏收录