Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    15

    Angry Unanswered: 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,

    Ken

  2. #2
    Join Date
    Apr 2003
    Posts
    15
    I found the answer....

    / 60.0 /60.0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •