Subtracting the difference between two time intervals in oracle sql

Asked Sep 21 '15 at 10:50

Active Sep 21 '15 at 11:14

Viewed 108 times

I would like to subtract the difference between two time intervals, e.g.:

I have

DECLARE FROM_TIME DATE = TO_DATE('03.12.2015:09:00','DD.MM.YYYY:HH24:MI'),
        TO_TIME DATE = TO_DATE('03.12.2015:10:24','DD.MM.YYYY:HH24:MI');

How do I get the difference (01:24) in time between FROM_TIME and TO_TIME?

Thanks in advance.

edited Sep 21 '15 at 10:54

jarlh

asked Sep 21 '15 at 10:50

Vincent Shikomba

How big can be difference? Hours\days\ more? – Viktor Bardakov Sep 21 '15 at 10:53
Start by subtracting one datetime from the other. Then format the result. – Dan Bracuk Sep 21 '15 at 10:58
Only hours and minutes. Can you give me an example please? – Vincent Shikomba Sep 21 '15 at 12:08

0 Answers0