Wednesday, March 7, 2012

Rounding error....

Hello,

I am trying to get a sum of hours from seconds, however it's rounding the result, how can I get it to not round?

example:

TABLE1

ID, Seconds, Job

Select sum(Seconds) as TimeInHours, Job from TABLE1

Group by Job

Thanks,

KenI found the answer...

/ 60.0 /60.0

No comments:

Post a Comment