CEILING( (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(dd.operate_time))/(24*3600) ) AS daysSum
MySQL 根据日期计算天数
最新推荐文章于 2024-07-21 03:12:17 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
CEILING( (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(dd.operate_time))/(24*3600) ) AS daysSum