MySQL 查询本周、本月、本季度、本年的数据

时间：2020-02-04 11:26:04 收藏：0 阅读：284

createdate=时间字段


1、本周

and  year(e.createdate)=year(NOW()) and  YEARWEEK( date_format(  e.CREATEDATE,‘%Y-%m-%d‘ ) ) = YEARWEEK( now() )

2、本月

and  year(e.createdate)=year(NOW()) AND DATE_FORMAT(e.CREATEDATE, ‘%Y-%m‘) = DATE_FORMAT(NOW(),‘%Y-%m‘)


3、本季度

and year(e.createdate)=year(NOW()) AND quarter(e.CREATEDATE) = quarter(NOW())


4、本年

and  year(e.createdate)=year(NOW())

原文：https://www.cnblogs.com/w-yu-chen/p/12258476.html