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!

OBIEE 11g - Change seconds to DD HH:MM:SS format

807018Jul 28 2011 — edited Jul 28 2011

Hi all,

I have a column in obiee that is 'Duration' in seconds - I was wondering how to view this as 'Days:Hours:Minutes:Seconds'

Tried custom number formats but no luck. I can quite simply change it into hours OR days via a simple calc in the column formula, but I need the full breakdown.

Any ideas??

Thanks

Ken

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2011

Added on Jul 28 2011

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

4 comments

2,684 views