本文主要給大家簡(jiǎn)單講講MySQL多種查詢時(shí)間數(shù)據(jù)方法，相關(guān)專業(yè)術(shù)語大家可以上網(wǎng)查查或者找一些相關(guān)書籍補(bǔ)充一下，這里就不涉獵了，我們就直奔主題吧，希望MYSQL多種查詢時(shí)間數(shù)據(jù)方法這篇文章可以給大家?guī)硪恍?shí)際幫助。                                                         

可克達(dá)拉ssl適用于網(wǎng)站、小程序/APP、API接口等需要進(jìn)行數(shù)據(jù)傳輸應(yīng)用場(chǎng)景，ssl證書未來市場(chǎng)廣闊！成為創(chuàng)新互聯(lián)的ssl證書銷售渠道，可以享受市場(chǎng)價(jià)格4-6折優(yōu)惠！如果有意向歡迎電話聯(lián)系或者加微信：13518219792（備注：SSL證書合作）期待與您的合作！

mysql查詢本季度

今天

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

昨天

SELECT *FROM表名WHERE TO_DAYS( NOW( ) ) – TO_DAYS( 時(shí)間字段名) <= 1

7天

SELECT *FROM表名 where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(時(shí)間字段名)

近30天

SELECT *FROM表名 where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(時(shí)間字段名)

本月

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

#查詢本季度數(shù)據(jù)
select * from `ht_invoice_information` where QUARTER(create_date)=QUARTER(now());
#查詢上季度數(shù)據(jù)
select * from `ht_invoice_information` where QUARTER(create_date)=QUARTER(DATE_SUB(now(),interval 1 QUARTER));
#查詢本年數(shù)據(jù)
select * from `ht_invoice_information` where YEAR(create_date)=YEAR(NOW());
#查詢上年數(shù)據(jù)
select * from `ht_invoice_information` where year(create_date)=year(date_sub(now(),interval 1 year));

查詢當(dāng)前這周的數(shù)據(jù)
SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,’%Y-%m-%d’)) = YEARWEEK(now());

查詢上周的數(shù)據(jù)
SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,’%Y-%m-%d’)) = YEARWEEK(now())-1;

查詢當(dāng)前月份的數(shù)據(jù)
select name,submittime from enterprisewhere date_format(submittime,’%Y-%m’)=date_format(now(),’%Y-%m’)

查詢距離當(dāng)前現(xiàn)在6個(gè)月的數(shù)據(jù)
select name,submittime from enterprise where submittime between date_sub(now(),interval 6 month) and now();

查詢上個(gè)月的數(shù)據(jù)
select name,submittime from enterprisewhere date_format(submittime,’%Y-%m’)=date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),’%Y-%m’)

select*from`user`whereDATE_FORMAT(pudate,‘%Y%m‘)=DATE_FORMAT(CURDATE(),‘%Y%m‘) ;
select * from user where WEEKOFYEAR(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = WEEKOFYEAR(now())

select*
fromuser
whereMONTH(FROM_UNIXTIME(pudate,‘%y-%m-%d‘))=MONTH(now())

select*
from[user]
whereYEAR(FROM_UNIXTIME(pudate,‘%y-%m-%d‘))=YEAR(now())
andMONTH(FROM_UNIXTIME(pudate,‘%y-%m-%d‘))=MONTH(now())

select*
from[user]
wherepudatebetween上月最后一天
and下月第一天

wheredate(regdate)=curdate();

select*fromtestwhereyear(regdate)=year(now())andmonth(regdate)=month(now())andday(regdate)=day(now())

SELECT date( c_instime ) ,curdate( )FROM `t_score`WHERE 1LIMIT 0 , 30

MYSQL多種查詢時(shí)間數(shù)據(jù)方法就先給大家講到這里，對(duì)于其它相關(guān)問題大家想要了解的可以持續(xù)關(guān)注我們的行業(yè)資訊。我們的板塊內(nèi)容每天都會(huì)捕捉一些行業(yè)新聞及專業(yè)知識(shí)分享給大家的。

網(wǎng)頁題目：MYSQL多種查詢時(shí)間數(shù)據(jù)方法
文章URL：http://vcdvsql.cn/article16/jhjggg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站建設(shè)、品牌網(wǎng)站設(shè)計(jì)、Google、全網(wǎng)營銷推廣、網(wǎng)站設(shè)計(jì)公司、自適應(yīng)網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)