Orcale trigger to realize how to calculate the time difference between time two

Calculation of two time difference hour how can orcale flip-flop

Started by Gino at November 24, 2016 - 4:10 AM

Two what time

Posted by Grover at December 04, 2016 - 4:40 AM

select ceil((To_date('2013-09-28 00:00:00', 'yyyy-mm-dd hh24-mi-ss') -
2 To_date('2013-09-26 23:59:59', 'yyyy-mm-dd hh24-mi-ss')) * 24)H
3 FROM DUAL;

H
----------
25

Posted by Avery at December 19, 2016 - 4:55 AM