mysql 怎么查詢?cè)路?/a>

mysql查詢?cè)路莸姆椒ǎ?、通過“select date_format(DATE_SUB(curdate(), INTERVAL 0 MONTH), ‘%m’)”查詢當(dāng)前月份；2、通過“INTERVAL 1 MONTH”查詢上個(gè)月份。

//查看本月數(shù)據(jù) SELECT * FROM content_publish WHERE date_format(publish_time,?'%Y?%m')?=?date_format(DATE_SUB(curdate(),?INTERVAL?0?MONTH),'%Y?%m') ? //查看上個(gè)月數(shù)據(jù) SELECT * FROM content_publish WHERE date_format(publish_time,?'%Y?%m')?=?date_format(DATE_SUB(curdate(),?INTERVAL?1?MONTH),'%Y?%m') ? //查詢上上個(gè)月數(shù)據(jù) SELECT * FROM content_publish WHERE date_format(publish_time,?'%Y?%m')?=?date_format(DATE_SUB(curdate(),?INTERVAL?2?MONTH),'%Y?%m') ? //查詢當(dāng)前月份 select?date_format(DATE_SUB(curdate(),?INTERVAL?0?MONTH),?'%m') //查詢上個(gè)月月份 select?date_format(DATE_SUB(curdate(),?INTERVAL?1?MONTH),?'%m') //查詢上上個(gè)月月份 select?date_format(DATE_SUB(curdate(),?INTERVAL?0?MONTH),?'%m')

select?*?from?表名?where?to_days(時(shí)間字段名)?=?to_days(now());

SELECT?*?FROM?表名?WHERE?TO_DAYS(?NOW(?)?)?-?TO_DAYS(?時(shí)間字段名)?<p>?</p><p>近7天</p><pre class="brush:php;toolbar:false">SELECT?*?FROM?表名?where?DATE_SUB(CURDATE(),?INTERVAL?7?DAY)?<p>?</p><p>近30天</p><pre class="brush:php;toolbar:false">SELECT?*?FROM?表名?where?DATE_SUB(CURDATE(),?INTERVAL?30?DAY)?<p>?</p><p>本月</p><pre class="brush:php;toolbar:false">SELECT?*?FROM?表名?WHERE?DATE_FORMAT(?時(shí)間字段名,?'%Y%m'?)?=?DATE_FORMAT(?CURDATE(?)?,?'%Y%m'?)

SELECT?*?FROM?表名?WHERE?PERIOD_DIFF(?date_format(?now(?)?,?'%Y%m'?)?,?date_format(?時(shí)間字段名,?'%Y%m'?)?)?=1

select?*?from?`ht_invoice_information`?where?QUARTER(create_date)=QUARTER(now());

select?*?from?`ht_invoice_information`?where?QUARTER(create_date)=QUARTER(DATE_SUB(now(),interval?1?QUARTER));

select?*?from?`ht_invoice_information`?where?YEAR(create_date)=YEAR(NOW());

select?*?from?`ht_invoice_information`?where?year(create_date)=year(date_sub(now(),interval?1?year));

SELECT?name,submittime?FROM?enterprise?WHERE?YEARWEEK(date_format(submittime,'%Y-%m-%d'))?=?YEARWEEK(now());

SELECT?name,submittime?FROM?enterprise?WHERE?YEARWEEK(date_format(submittime,'%Y-%m-%d'))?=?YEARWEEK(now())-1;

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?下月第一天

select?name,submittime?from?enterprise???where?date_format(submittime,'%Y-%m')=date_format(now(),'%Y-%m')

select?name,submittime?from?enterprise?where?submittime?between?date_sub(now(),interval?6?month)?and?now();