Print Page - float to seconds

Title: float to seconds
Post by: orbair on 27 Jun 2014 06:14:40 AM

Hi all,

I have a field type float, which represent second. In my report I have to show time format: for ex 180 like 3:00.
I've tried cast(field, interval second) then in the report I've changed the format to time, but showed me the same number and milliseconds. Can you please advise?

thanks

Title: Re: float to seconds
Post by: BigChris on 27 Jun 2014 06:50:22 AM

I imagine you'll need to divide by 60...you'll need to experiment with floor and mod functions (sorry I can't be more help...I don't have RS at the moment)

Title: Re: float to seconds
Post by: orbair on 04 Jul 2014 10:33:54 AM

I resolved in SQL Server...it was easier

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: orbair on 27 Jun 2014 06:14:40 AM