oracle中查询一月的时间补0的问题

 

sql语句

select nvl(b.weight, 0),a.time from
(select to_char(to_date(开始时间, 'yyyy-mm-dd') + rownum - 1, 'yyyy-mm-dd') as time
from dual
connect by rownum <= trunc(to_date(结束时间, 'yyyy-mm-dd') - to_date(开始时间, 'yyyy-mm-dd')) + 1) a
left join (

自己的业务

) b on a.time = b.time order by a.time desc     

实现效果