-- 按年统计数量
select date_format(dReport,'%Y') as yearmonth,count(*) from monitorday group by date_format(dReport,'%Y');
-- 按年-月统计数量
select date_format(dReport,'%Y-%m') as yearmonth,count(*) from monitorday group by date_format(dReport,'%Y-%M');
-- 按年-月-日统计数量
select date_format(dReport,'%Y-%m-%d') as yearmonth,count(*) from monitorday group by date_format(dReport,'%Y-%M-%d');