mysql查询今日、本周、本月记录

SELECT * FROM table_name WHERE to_days(createtime) = to_days(now());

SELECT * FROM table_name WHERE YEARWEEK(date_format(createtime,'%Y-%m-%d')- INTERVAL 1 DAY) = YEARWEEK(now());

 

SELECT * FROM table_name WHERE date_format(createtime,'%Y-%m')=date_format(now(),'%Y-%m')

posted @   任飞儿  阅读(2321)  评论(1编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示