hh-mm-ss format problem ?

[Ayato]

Hello @ll,

In Cognos report net, I need to format a amount of seconds to hh.mm.ss format.

Any idea how to do that ?

e.g: 120 = 00:02:00

regards,
Ayato

 

[RoMaxx77]

Thank you. I will test it and give you some feedback.

 

[RoMaxx77]

It works fine but we don't need milli seconds - but that is no problem.

Does it also works with MR2? Because we have installed MR1 again.

 

[Draoued]

tested in ReportNet Version: 1.1.230.2
I think this is MR1 , but the calculation uses only Oracle basic function , so I m quite sure that it will work in MR2.