Thursday, 20 September 2012

How to find Difference between time in Oracle

select round(((Request_End_Date-Request_Start_Date) * 24*60*60)) as second_difference,
round(((Request_End_Date-Request_Start_Date) * 24*60)) as minute_difference
from Request_log

No comments:

Post a Comment