Progress convert seconds to hours

[system]

Hello,

I’m using a universe on a Progress database. In the database there is field which contains seconds. I want to convert this to human readable notation like hh:mm.

How do I convert seconds to hours/minutes in Progress? (hh:mm).

---

rick81nl (BOB member since 2011-05-25)

[system]

Hi Rick,

Have you tried searching for the logic on this forum?

Here are couple of discussions;

120×120 10.4 KB

Dear BOB, I have a column in the database which is having seconds. Please assist to create a universe level object for converting seconds into HH:MM:SS format. HUJ (BOB member since 2010-03-29)

120×120 10.4 KB

In designer I have a duration time in seconds, I need to convert that to dd:hh:mm format who can help me to handle this It’s urgency!!! Thanks funny (BOB member since 2008-09-24)

---

izak004 (BOB member since 2010-11-10)

[system]

Yes, I tried searching, but almost every solution is for SQL Server or Oracle. I am using Progress and functions like CONVERT and DATEADD do not work. I need a Progress specific solution.

Already tried TO_CHAR, but it gives an ‘error on fetch’ error message.

---

rick81nl (BOB member since 2011-05-25)