with t0 as (
select
to_date('11/10/2010 00:00:00','dd/mm/yyyy hh24:mi:ss') data_inicial,
to_date('11/10/2010 23:59:59','dd/mm/yyyy hh24:mi:ss') data_final
from dual),
t1 as (
select data_final - data_inicial diferenca from t0
)
select
trunc(diferenca)*12 + trunc((diferenca - trunc(diferenca))*24) horas
from t1;
o mesmo ocorre aqui..
with t0 as (
select
to_date('11/10/2010 08:00:00','dd/mm/yyyy hh24:mi:ss') data_inicial,
to_date('15/10/2010 10:00:00','dd/mm/yyyy hh24:mi:ss') data_final
from dual),
t1 as (
select data_final - data_inicial diferenca from t0
)
select
trunc(diferenca)*12 + trunc((diferenca - trunc(diferenca))*24) horas
from t1;
abraço e obrigado a todos!!