SELECT * FROM `nation`
where to_days(create_time) = to_days(now())
SELECT * FROM `nation`
where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(create_time)
SELECT * FROM `nation`
where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)
SELECT * FROM `nation`
where to_days(create_time) = to_days(now())
SELECT * FROM `nation`
where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(create_time)
SELECT * FROM `nation`
where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)