一张图记录sql按季度统计的坑

今天修改数据库偶然间发现小程序端报表显示的数据量与数据库数据不符合，显示数据明显多于数据库，检查了sql才发现季度统计的坑。特作记录：

案例记录：

一、 错误的

		SELECT YEAR(STR_TO_DATE(t.store_time,'%Y-%m-%d')) as year,QUARTER(STR_TO_DATE(t.store_time,'%Y-%m-%d')) as quarter,count(t.store_time) as  count from t_xxx_xxx_xxx t
		WHERE quarter(STR_TO_DATE(t.store_time,'%Y-%m-%d')) = quarter(now())  and t.store_code ='1234'

错误的七条数据

二、 正确的

		SELECT YEAR(STR_TO_DATE(t.store_time,'%Y-%m-%d')) as year,QUARTER(STR_TO_DATE(t.store_time,'%Y-%m-%d')) as quarter,count(t.store_time) as  count from t_xxx_xxx_xxx t
		WHERE quarter(STR_TO_DATE(t.store_time,'%Y-%m-%d')) = quarter(now()) and  year(STR_TO_DATE(t.store_time,'%Y-%m-%d')) = year(now()) and t.store_code ='1234'

正确五条数据