1.datediff()
这两个是等价的
也就是2019-07-27到activity_date的时间间隔小于30
WHERE datediff('2019-07-27',activity_date) < 30
-- WHERE activity_date BETWEEN '2019-06-28' AND '2019-07-27'
1.datediff()
这两个是等价的
也就是2019-07-27到activity_date的时间间隔小于30
WHERE datediff('2019-07-27',activity_date) < 30
-- WHERE activity_date BETWEEN '2019-06-28' AND '2019-07-27'