float to seconds

[orbair]

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

[BigChris]

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)

[orbair]

I resolved in SQL Server...it was easier