contoh query time different beda hari dalam detik

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;