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

首页 > 技术文章 > MySQL 查询本周、本月、本季度、本年的数据

w-yu-chen 2020-02-04 10:17 原文

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())