1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| with matable (cid, debut, fin) as
(
select 1, timestamp '2015-03-03 10:00:00', timestamp '2015-03-03 12:30:00' from dual union all
select 2, timestamp '2015-03-03 10:00:00', timestamp '2015-03-07 12:30:00' from dual union all
select 3, timestamp '2015-03-03 17:30:00', timestamp '2015-03-02 12:30:00' from dual
)
select cid, debut, fin
, fin - debut as df1
, (fin - trunc(fin)) - (debut - trunc(debut)) as df2
from matable;
CID DEBUT FIN DF1 DF2
---------- ------------------- ---------------- ------------ -------------
1 2015-03-03 10:00:00 2015-03-03 12:30 +00 02:30:00 +00 02:30:00
2 2015-03-03 10:00:00 2015-03-07 12:30 +04 02:30:00 +00 02:30:00
3 2015-03-03 17:30:00 2015-03-02 12:30 -01 05:00:00 -00 05:00:00 |
Partager