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!

Difference between dates in hours

884519Jan 7 2013 — edited Jan 8 2013
Hi All,

I need to display difference between two date fields and the resule should display like XX Hours, XX minutes.

eg: select ((completion_date - start_date)*24*60) AS run_time from xx_dba_programs;

Expected O/P : 3 Hours, 25 Minutes.



Database is Oracle 11g(Rel.2)

Thanks,
gvk.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2013
Added on Jan 7 2013
15 comments
38,647 views