Estrazione differenza tra date
Estrazione differenza tra due date in giorni, ore e minuti.
select
trunc(
to_date('17092019 10:45:00','ddmmyyyy hh24:mi:ss') -
to_date('15092019 06:30:45','ddmmyyyy hh24:mi:ss')) giorni,
trunc( 24* mod(
to_date('17092019 10:45:00','ddmmyyyy hh24:mi:ss') -
to_date('15092019 06:30:45','ddmmyyyy hh24:mi:ss'),1
)) as ore,
trunc( mod(mod(
to_date('17092019 10:45:00','ddmmyyyy hh24:mi:ss') -
to_date('15092019 06:30:45','ddmmyyyy hh24:mi:ss'),1
)*24,1)*60 ) as min
from dual
GIORNI ORE MIN
---------- ---------- --------------------
2 4 14
select
trunc(
to_date('17092019 10:45:00','ddmmyyyy hh24:mi:ss') -
to_date('15092019 06:30:45','ddmmyyyy hh24:mi:ss')) giorni,
trunc( 24* mod(
to_date('17092019 10:45:00','ddmmyyyy hh24:mi:ss') -
to_date('15092019 06:30:45','ddmmyyyy hh24:mi:ss'),1
)) as ore,
trunc( mod(mod(
to_date('17092019 10:45:00','ddmmyyyy hh24:mi:ss') -
to_date('15092019 06:30:45','ddmmyyyy hh24:mi:ss'),1
)*24,1)*60 ) as min
from dual
GIORNI ORE MIN
---------- ---------- --------------------
2 4 14