Results 1 to 2 of 2

Thread: sum time

  1. #1
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132

    Unanswered: sum time

    hi,

    how can i sum this ---> subtime(time_end,time_start) as Overtime

    i use group by, but the result is '0'.


    thanks in advance....
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    SEC_TO_TIME(SUM(TIME_TO_SEC(SUBTIME(time_end,time_ start))))
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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