elect
user_id,
user_name,
createtime
from
t_user
where
DATE_SUB ( CURDATE (), INTERVAL 1 MONTH ) <= date (createtime);
user_id,
user_name,
createtime
from
t_user
where
DATE_SUB ( CURDATE (), INTERVAL 1 MONTH ) <= date (createtime);
同理,近一个星期为:
INTERVAL 7 DAY
。