Skip to Main Content

APEX

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!

Display number of seconds as Days,Hours,Minutes,Seconds

Padmocho-OracleJun 4 2018 — edited Jun 4 2018

Hi,

I have a table with a number column called DURATION. This column holds the number of seconds that has passed between two timestamps.

In IR - how can I display this information in a more friendly way (e.g. 10 days 5 Hrs 10 Minutes)?

Best regards,

Pawel.

This post has been answered by fac586 on Jun 4 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2018
Added on Jun 4 2018
7 comments
3,268 views