select DATE_FORMAT(creatTime,'%Y-%m-%d') as time,COUNT(id) as 数量 from 表名 WHERE <![CDATA[ DATE_FORMAT(creatTime,'%Y-%m-%d') >= #{startTime} ]]> and <![CDATA[ DATE_FORMAT(creatTime,'%Y-%m-%d') <= #{endTime} ]]> GROUP BY time ORDER BY time
备注: creatTime 是表中日期记录字段。
startTime是开始时间。
endTime 是结束时间。
示例
select
DATE_FORMAT(creatTime,'%Y-%m-%d') as time,COUNT(id) as 数量
from zcts_policy
WHERE
DATE_FORMAT(creatTime,'%Y-%m-%d') >= '2019-03-01'
and
DATE_FORMAT(creatTime,'%Y-%m-%d') <= '2019-11-05'
GROUP BY time
ORDER BY time