Question: how to calculate time difference between two columns in oracle sql?
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,