select (datediff(date_add( DATE_FORMAT('2021-02-06','%Y-%m-%d'), interval 1 day), '2021-02-05')) AS residueDays
sql实现两时间差,当日期相同时算一天
最新推荐文章于 2023-11-23 17:15:52 发布
select (datediff(date_add( DATE_FORMAT('2021-02-06','%Y-%m-%d'), interval 1 day), '2021-02-05')) AS residueDays