Question: how to calculate time difference in hours and minutes and seconds in oracle sql?
Answer: The difference in hours, minutes or seconds can be found by multiplying this number by 24 , 24*60 or 24*60*60 respectively. );