Below query which is used
select
function(‘to_char’,w1.startTime,‘dd/mm/yyyy’),(sum(w1.duration_in_milli_second)/3600000) exe_count
from worklog$WorkLog w1
where @between(w1.startTime,now-5,now,day,user_timezone)
group by w1.startTime
order by w1.startTime