sql docs test

with P as (
    select 
    DAYTIME as DAYTIME, 
    sum(NET_VOL) as AP
    from dv_strm_day_pc_alloc
    where DAYTIME between (select TRUNC (sysdate,'YEAR') from DUAL) and (select TRUNC (CURRENT_DATE) from DUAL)
    and OBJECT_CODE = 'BAL1001'
    and PROFIT_CENTRE_CODE in ('BALDER_FIELD', 'RHE_FIELD', 'RH_FIELD')
    group by DAYTIME
),
Q as (
    select 
    ((select TRUNC (sysdate,'YEAR') from DUAL) %2B (LEVEL - 1)) as DAYTIME,
    (select 0 from dual) as ZERO
    from DUAL
    connect by level <=( sysdate-((select TRUNC (sysdate,'YEAR') from DUAL)))    
)
select 
concat(to_char(Q.DAYTIME,'YYYY-MM-DD'),'T00:00:00') as %22x%22,
round(coalesce(P.AP,0),0) as %22y%22
from Q 
left join P on Q.DAYTIME = P.DAYTIME
order by Q.DAYTIME