mysql如何查詢一天內的數據

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

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

SELECT?*?FROM?表名?WHERE?PERIOD_DIFF(?date_format(?now(?)?,?'%Y%m'?)?,?date_format(?時間字段名,?'%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();