#獲取當月數(shù)據(jù) SELECT?*?FROM?user_event?WHERE?DATE_FORMAT(create_time,'%Y-%m')?=?DATE_FORMAT(NOW(),'%Y-%m')#獲取3月份數(shù)據(jù) SELECT?*?FROM?user_event?WHERE?DATE_FORMAT(create_time,'%Y-%m')?=?DATE_FORMAT('2016-03-01','%Y-%m')#獲取三月份數(shù)據(jù) SELECT?*?FROM?user_event?WHERE?YEAR(create_time)='2016'?AND?MONTH(create_time)='3'#獲取本周數(shù)據(jù) SELECT?*?FROM?user_event?WHERE?YEARWEEK(DATE_FORMAT(create_time,'%Y-%m-%d'))?=?YEARWEEK(NOW());?#查詢上周的數(shù)據(jù)? SELECT?*?FROM?user_event?WHERE?YEARWEEK(DATE_FORMAT(create_time,'%Y-%m-%d'))?=?YEARWEEK(NOW())-1;?#查詢距離當前現(xiàn)在6個月的數(shù)據(jù)? SELECT?*?FROM?user_event?WHERE?create_time?BETWEEN?DATE_SUB(NOW(),interval?6?month)?and?NOW();#查詢上個月的數(shù)據(jù)? SELECT?*?FROM?user_event?WHERE?DATE_FORMAT(create_time,'%Y-%m')=DATE_FORMAT(DATE_SUB(CURDATE(),?INTERVAL?1?MONTH),'%Y-%m')#查詢今天的信息記錄： SELECT?*?FROM?user_event?WHERE?TO_DAYS(`create_time`)?=?TO_DAYS(NOW());#查詢昨天的信息記錄： SELECT?*?FROM?user_event?WHERE?TO_DAYS(now())?-?TO_DAYS(create_time)?<=?1;#查詢近7天的信息記錄： SELECT?*?FROM?user_event?WHERE?DATE_SUB(curdate(),?INTERVAL?7?DAY)?<=?DATE(create_time);#查詢近30天的信息記錄： SELECT?*?FROM?user_event?WHERE?DATE_SUB(curdate(),?INTERVAL?30?DAY)?<=?DATE(create_time);#查詢上一月的信息記錄： SELECT?*?FROM?user_event?WHERE?PERIOD_DIFF(DATE_FORMAT(NOW(),?'%Y%m'),?DATE_FORMAT(create_time,?'%Y%m'))?=1;

轉(zhuǎn)載于:https://blog.51cto.com/3391861/2117302

總結(jié)

以上是生活随笔為你收集整理的MySQL查询指定时间的数据的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。