round off

[soniasweety]

Hi all,

I am still facing the issue with the format.

I have written this in script

num(floor( duration)/3600,'##.##') as  mytime,

duration in seconds. 

but I need  to show with two decimal

am getting output like below    I need  1274.62  like that

1274.621667

1012.946389

[avinashelite]

What is time format is it in the UNIX ? then we need to convert the time and then do the round off