pg按时间查询日期范围内的统计情况

select c.*,coalesce(d.incidentTotal,0) as total from (
select a.rq,b.dm,b.mc from (
select to_char(daytime::date,'mm-dd') as rq from generate_series(
num_to_date(1)::TIMESTAMP, --开始日期
num_to_date(12312312312)::TIMESTAMP, --结束日期
'1 day'::INTERVAL
) s(daytime) ) a,
(select dm,mc from t_dm_bjfs where yxbz = '1') b
) c left join (
SELECT
sj.bjfs alarmWayType,
to_char(to_timestamp(scbjsj/1000),'mm-dd') as rq,
count (sjdbh) incidentTotal
FROM
ywb sj,
dm_01 bjfs
WHERE
sj.scbjsj >= 1
AND sj.scbjsj <= 123213213123123
AND sj.cljg <> '1'
AND sj.bjfs = bjfs.dm
AND sj.xqdw IN ('1000')
and bjfs.yxbz = '1'
GROUP BY
bjfs.mc,
sj.bjfs,
to_char(to_timestamp(scbjsj/1000),'mm-dd')) d on c.dm = d.alarmWayType and c.rq = d.rq
order by rq,dm