Question: how to find difference between two times in oracle?
Answer: Hi, Just multiply your Hrs with 60, add Minutes to it and substract THE TARGET. ... 
This query will give difference in minutes... select to_number(to_date('01-Sep-03 2:00 PM','DD-Mon-YY HH:MI AM') - ... 
Hi again, ... 
here is some code for 24 hours notation first understand then implement it. ... 
Hi Himanshu. ... 
Hi,