Display an integer as a time interval

[HMK]

Hi there,

I've got a column of integer data representing seconds, that I'd like to be able to display as a time interval (HH:mm:ss) in an Impromptu report.
Ie, get a number like 506 and display it as 00:08:26
and do this for a whole column of data.

Has anyone come up with a solution for this one using Impromptu?

There doesn't appear to be a function to convert from integer to interval, or any way to manipulate a number representing seconds into a time.

 

[griffindm]

HMK,

You could probably do this with a combination of number-to-string, division, modulus, and integer-divide(which is unfortunately a local function.

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com

 

[HMK]

I've already gone that route, coming up with separate integers representing hours minutes and seconds through a mathematical formula performed upon the data, but I need to be able to display them as an interval - in interval format - in my impromptu report.

 

[griffindm]

HMK,

Sorry but I don't see any function in Impromptu that allows that. Why do you need it as a true interval for your report?. Are you using the result in date math on other true dates? The conversion routine should be able to display it in interval convention (DDD HH:MM:SS) even without it being a true interval.

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com

 

[HMK]

If there is a conversion routine available to string a bunch of numbers together separated by colons all in the same field, I haven't discovered it.