![](https://img.haomeiwen.com/i9280850/b30794f8643771ce.png)
- DATE_SUB(date,INTERVAL expr type) 从日期减去指定的时间间隔
文档:http://w3school.com.cn/sql/func_date_sub.asp
举例:DATE_SUB(now(),INTERVAL 2 DAY) as twoDayAgo
两天前 - DATEDIFF(date1,date2) 返回两个日期之间的天数
文档:https://www.w3school.com.cn/sql/func_datediff_mysql.asp
举例:SELECT DATEDIFF('2008-12-30','2008-12-29') AS DiffDate
结果为1
网友评论