\u5f15\u7528 https:\/\/www.cnblogs.com\/shuilangyizu\/p\/8805384.html<\/p>\n
--\u4eca\u5929\n\nselect * from \u8868\u540d where to_days(\u65f6\u95f4\u5b57\u6bb5\u540d) = to_days(now());\n\n--\u6628\u5929\n\nSELECT * FROM \u8868\u540d WHERE TO_DAYS( NOW( ) ) - TO_DAYS( \u65f6\u95f4\u5b57\u6bb5\u540d) <= 1<\/pre>\nAND TO_DAYS(NOW()) - TO_DAYS(update_time)>0<\/pre>\n--\u672c\u5468 SELECT * FROM \u8868\u540d WHERE YEARWEEK( date_format( \u65f6\u95f4\u5b57\u6bb5\u540d,'%Y-%m-%d' ) ) = YEARWEEK( now() ) ; --\u672c\u6708 SELECT * FROM \u8868\u540d WHERE DATE_FORMAT( \u65f6\u95f4\u5b57\u6bb5\u540d, '%Y%m' ) = DATE_FORMAT( CURDATE( ) ,'%Y%m' ) --\u4e0a\u4e00\u4e2a\u6708 SELECT * FROM \u8868\u540d WHERE PERIOD_DIFF(date_format(now(),'%Y%m'),date_format(\u65f6\u95f4\u5b57\u6bb5\u540d,'%Y%m') =1 --\u672c\u5e74 SELECT * FROM \u8868\u540d WHERE YEAR( \u65f6\u95f4\u5b57\u6bb5\u540d ) = YEAR( NOW( ) ) --\u4e0a\u4e00\u6708 SELECT * FROM \u8868\u540d WHERE PERIOD_DIFF( date_format( now( ) , '%Y%m' ) , date_format( \u65f6\u95f4\u5b57\u6bb5\u540d, '%Y%m' ) ) =1 --\u67e5\u8be2\u672c\u5b63\u5ea6\u6570\u636e select * from `ht_invoice_information` where QUARTER(create_date)=QUARTER(now()); --\u67e5\u8be2\u4e0a\u5b63\u5ea6\u6570\u636e select * from `ht_invoice_information` where QUARTER(create_date)=QUARTER(DATE_SUB(now(),interval 1 QUARTER)); --\u67e5\u8be2\u672c\u5e74\u6570\u636e select * from `ht_invoice_information` where YEAR(create_date)=YEAR(NOW()); --\u67e5\u8be2\u4e0a\u5e74\u6570\u636e select * from `ht_invoice_information` where year(create_date)=year(date_sub(now(),interval 1 year)); --\u67e5\u8be2\u5f53\u524d\u8fd9\u5468\u7684\u6570\u636e SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,'%Y-%m-%d')) = YEARWEEK(now()); --\u67e5\u8be2\u4e0a\u5468\u7684\u6570\u636e SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,'%Y-%m-%d')) = YEARWEEK(now())-1; --\u67e5\u8be2\u5f53\u524d\u6708\u4efd\u7684\u6570\u636e select name,submittime from enterprise where date_format(submittime,'%Y-%m')=date_format(now(),'%Y-%m') --\u67e5\u8be2\u8ddd\u79bb\u5f53\u524d\u73b0\u57286\u4e2a\u6708\u7684\u6570\u636e select name,submittime from enterprise where submittime between date_sub(now(),interval 6 month) and now(); --\u67e5\u8be2\u4e0a\u4e2a\u6708\u7684\u6570\u636e 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 \u4e0a\u6708\u6700\u540e\u4e00\u5929 and \u4e0b\u6708\u7b2c\u4e00\u5929 where date(regdate) = curdate(); select * from test where year(regdate)=year(now()) and month(regdate)=month(now()) and day(regdate)=day(now()) SELECT date( c_instime ) ,curdate( ) FROM `t_score` WHERE 1 LIMIT 0 , 30<\/pre>\n","protected":false},"excerpt":{"rendered":"