contoh query time different beda hari dalam detik yang dihitung jumlahnya

select beda_wkt, count(beda_wkt)
from
(
select (case when to_date(dtm2,'DD-MM-YYYY') <> to_date(dtm1,'DD-MM-YYYY') and to_date(dtm2,'DD-MM-YYYY') = to_date(dtm1,'DD-MM-YYYY')+1 then (to_number(to_char(dtm2,'SSSSS')) - to_number(to_char(dtm1,'SSSSS')))+86400 else to_number(to_char(dtm2,'SSSSS')) - to_number(to_char(dtm1,'SSSSS')) end) as beda_wkt from test2
)
group by beda_wkt;