https://www.cnblogs.com/zhangqunshi/p/6679847.html
select user_id,
user_name,
createtime from t_user where DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= date(createtime);
- 版权声明：本站原创文章，于7年前，由发表，共 152字。
- 转载请注明：mysql一个月前 | 老鄢博客 +复制链接
https://www.cnblogs.com/zhangqunshi/p/6679847.html
select user_id,
user_name,
createtime from t_user where DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= date(createtime);
