MySQL\u67e5\u8be2\u7684\u65b9\u5f0f\u5f88\u591a\uff0c\u4e0b\u9762\u4e3a\u60a8\u4ecb\u7ecd\u7684MySQL\u67e5\u8be2\u5b9e\u73b0\u7684\u662f\u67e5\u8be2\u672c\u5468\u3001\u4e0a\u5468\u3001\u672c\u6708\u3001\u4e0a\u4e2a\u6708\u4efd\u7684\u6570\u636e\uff0c\u5982\u679c\u60a8\u5bf9MySQL\u67e5\u8be2\u65b9\u9762\u611f\u5174\u8da3\u7684\u8bdd\uff0c\u4e0d\u59a8\u4e00\u770b\u3002<\/p>\n
\u67e5\u8be2\u5f53\u524d\u8fd9\u5468\u7684\u6570\u636e
\nSELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,’%Y-%m-%d’)) = YEARWEEK(now());<\/p>\n
\u67e5\u8be2\u4e0a\u5468\u7684\u6570\u636e
\nSELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,’%Y-%m-%d’)) = YEARWEEK(now())-1;<\/p>\n
\u67e5\u8be2\u5f53\u524d\u6708\u4efd\u7684\u6570\u636e
\nselect name,submittime from enterprise\u00a0\u00a0 where date_format(submittime,’%Y-%m’)=date_format(now(),’%Y-%m’)<\/p>\n
\u67e5\u8be2\u8ddd\u79bb\u5f53\u524d\u73b0\u57286\u4e2a\u6708\u7684\u6570\u636e
\nselect name,submittime from enterprise where submittime between date_sub(now(),interval 6 month) and now();<\/p>\n
\u67e5\u8be2\u4e0a\u4e2a\u6708\u7684\u6570\u636e
\nselect name,submittime from enterprise\u00a0\u00a0 where date_format(submittime,’%Y-%m’)=date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),’%Y-%m’)<\/p>\n
select * from `user` where DATE_FORMAT(pudate,’%Y%m’) = DATE_FORMAT(CURDATE(),’%Y%m’) ;<\/p>\n
select * from user where WEEKOFYEAR(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = WEEKOFYEAR(now())<\/p>\n
select *
\nfrom user
\nwhere MONTH(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = MONTH(now())<\/p>\n
select *
\nfrom [user]
\nwhere YEAR(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = YEAR(now())
\nand MONTH(FROM_UNIXTIME(pudate,’%y-%m-%d’)) = MONTH(now())<\/p>\n
select *
\nfrom [user]
\nwhere pudate between \u4e0a\u6708\u6700\u540e\u4e00\u5929
\nand \u4e0b\u6708\u7b2c\u4e00\u5929<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL\u67e5\u8be2\u7684\u65b9\u5f0f\u5f88\u591a\uff0c\u4e0b\u9762\u4e3a\u60a8\u4ecb\u7ecd\u7684MySQL\u67e5\u8be2\u5b9e\u73b0\u7684\u662f\u67e5\u8be2\u672c\u5468\u3001\u4e0a\u5468\u3001\u672c … \u7ee7\u7eed\u9605\u8bfb