MySQL查看当天未来一周未来一个月

-- 查看当天
SELECT * FROM `schedule` where TO_DAYS(warndate) = TO_DAYS(NOW())

-- 查看未来7天(  小于未来的7天, 大于今天  )
SELECT * FROM `schedule`  where  DATE_ADD(CURDATE(), INTERVAL 7 DAY) >= date(warndate)  AND  date(warndate) >= NOW()

-- 查看未来1个月(  小于未来的30天, 大于今天  )
SELECT * FROM `schedule`  where  DATE_ADD(CURDATE(), INTERVAL 30 DAY) >= date(warndate)  AND  date(warndate) >= NOW()

精确到天的不精确到小时:

-- 查看当天
SELECT * FROM `schedule` where TO_DAYS(warndate) = TO_DAYS(NOW())

-- 查看未来7天(  小于未来的7天, 大于今天 (精确到天的不精确到小时) )
SELECT * FROM `schedule`  where  TO_DAYS(DATE_ADD(CURDATE(), INTERVAL 7 DAY)) >= TO_DAYS(date(warndate))  AND  TO_DAYS(date(warndate)) >= TO_DAYS(NOW())


-- 查看未来1个月(  小于未来的30天, 大于今天   (精确到天的不精确到小时) )
SELECT * FROM `schedule`  where  TO_DAYS(DATE_ADD(CURDATE(), INTERVAL 30 DAY)) >= TO_DAYS(date(warndate))  AND  TO_DAYS(date(warndate)) >= TO_DAYS(NOW())