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!

Finding age of a record in Days, Hours & mins

DBQuestMay 7 2018 — edited May 7 2018

Hi,

I have a table order_request. I want to find exact age of a request in Days, Hours and Minutes based on creation_date and SYSDATE. For example if it is 4 Days, 6 Hours and 30 Mins old from sysdate. I want to display like 04:06:30.

order_request (request_id number primary key, request_type varchar2(50), created_on DATE, created_by varchar2(50), update_by varchar2(50), update_on DATE);

Please advise on this.

This post has been answered by Stew Ashton on May 7 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2018

Added on May 7 2018

7 comments

1,170 views