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