Convert seconds into HH:MM:SS format

[system]

Dear BOB,
I have a column in the database which is having seconds.
Please assist to convert seconds into HH:MM:SS format

---

HUJ (BOB member since 2010-03-29)

[system]

Hi,

Give the seconds as parameter it will give you in the format u want.
You can create an object in universe with definition

INTERVAL '8900' SECOND 

Sample SQL:

select INTERVAL '8900' SECOND from dual

---

billu (BOB member since 2009-11-09)

[system]

knra86,

Here is an older topic where a formula for DeskI is mentioned:

Convert number of seconds to actual time

We have a value in our database that is the number of seconds past midnight. Is there a way to convert this to hh:mm:ss in Business Objects (hh:mm would suffice) Many thanks in anticipation caz (BOB member since 2007-04-11)

It should not be a problem to re-write the formula for WebI.

---

Marek Chladny (BOB member since 2003-11-27)