Analytics Software

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!

Convert milliseconds to DD:HH:MM:SS

EricPSU05Apr 1 2016 — edited Apr 5 2016

I have a fact that is displaying the number of milliseconds between two dates that is calculated by a database view. I want to display this fact as "7 Days 14 Hours 45 Minutes 12 Seconds". What formula should I use to convert milliseconds to that output? Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2016

Added on Apr 1 2016

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

2,239 views