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