查詢上個月的數(shù)據(jù)
select name,submittime from enterprise where date_format(submittime,’%Y-%m’)=date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),’%Y-%m’)
select * from user where DATE_FORMAT(pudate,’%Y%m’) = DATE_FORMAT(CURDATE(),’%Y%m’) ;
select * from user where WEEKOFYEAR(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = WEEKOFYEAR(now())
select * from user where MONTH(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = MONTH(now())
select * from user where YEAR(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = YEAR(now()) and MONTH(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = MONTH(now())
select * from user where pudate between 上月最后一天 and 下月第一天
查詢當前月份的數(shù)據(jù)
select name,submittime from enterprise where date_format(submittime,’%Y-%m’)=date_format(now(),’%Y-%m’)
查詢距離當前現(xiàn)在6個月的數(shù)據(jù)
select name,submittime from enterprise where submittime between date_sub(now(),interval 6 month) and now();

以上關于本文的內(nèi)容，僅作參考！溫馨提示：如遇健康、疾病相關的問題，請您及時就醫(yī)或請專業(yè)人士給予相關指導!

• 運動專家教你10招　選到最適合的運動鞋
• 教你如何在陌陌聊天 什么是陌陌聊天
• 教你如何消除“將軍肚”
• 教你客家有名的蒸肉湯 客家粉蒸肉
• 睡前健身小動作 教你快速入眠
• 保健品批文查詢 保健食品批文查詢
• 我想查詢EMS運單號：EH685684185CN 的貨物送到哪里了 ems運單查詢
• 08年5月hsk成績查詢 k成績
• 教你如何制服花心男？花心男最愛9種女人
• 進入感情的倦怠期？教你3個愛情保鮮的妙招