mysql关于数据季度，月份分类的sql写法

当前年季度查询个数

select 
((MONTH( ss.createTime)-1) DIV 3) +1,count(*)
 from s_securitygrades ss
 where
  date_format(ss.createTime,'%Y')=Year(CurDate())
group by YEAR( ss.createTime)*10+((MONTH( ss.createTime)-1) DIV 3) +1

上面这个用在mybatis里面找不到div需要改为如下

select 
         FLOOR( (MONTH( ss.createTime)-1) / 3)+1,count(*)
         from s_securitygrades ss
         WHERE    
         date_format(ss.createTime,'%Y')=Year(CurDate())
         and  ss.`companyId` = 139
         group by
         YEAR( ss.createTime)*10+FLOOR( (MONTH( ss.createTime)-1) / 3)+1

当前年月份查询个数

COUNT( * ) denggerNum,
	date_format( shd.createTime, '%m' ) months
	FROM
	s_hidden_danger shd
    where
     date_format(shd.createTime,'%Y')=Year(CurDate())
     GROUP BY
	date_format( shd.createTime, '%m' )
	ORDER BY
	months