Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Function to get difference in hours and minutes between two oracle dates

user5716448May 5 2017 — edited May 10 2017

Hi,

Using oracle 11.2.0.3

Have 2 date datatypes in table and wish to express difference between these two dates as HH:MM

What is best way to do this/is there an inbuilt oracle function which would allow this?

Thanks
This post has been answered by GregV on May 5 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2017
Added on May 5 2017
12 comments
8,026 views