List:General Discussion« Previous MessageNext Message »
From:Dobromir Velev Date:October 24 2005 12:32pm
Subject:Re: sum of time?
View as plain text  
I think there should be no problem to use the SUM() function - did you tried 
it like this

select SEC_to_time(SUM(unix_timestamp(TTendTime) - 
unix_timestamp(TTstartTime))) as endtime
FROM TimeTracking
WHERE TTperson = 1  and date(TTstartTime) = '2005-10-19'

HTH

-- 
Dobromir Velev
dobromir@stripped
http://www.websitepulse.com/

On Monday 24 October 2005 07:48, jabbott@stripped wrote:
> I have a table doing time tracking.  I don't use timestamps, I use datetime
> fields to record punch in times and punch out times.  I have this query
> that computes the amount of time between a punch in and punch out:
>
> select SEC_to_time(unix_timestamp(TTendTime) - unix_timestamp(TTstartTime))
> as endtime
> FROM TimeTracking
> WHERE TTperson = 1
>     and date(TTstartTime) = '2005-10-19'
>
> And this works great except for when people punch in and out several times
> in one day.  Is there any way I can total a number of records into one
> total time?  In this example case, I am TTperson #1 and I punched in and
> out five times this day.
>
> I know I can do it in the code, but if I can do it in sql, life would be
> better for me.
>
> --ja
>
> --
Thread
sum of time?jabbott24 Oct
  • Re: sum of time?Dobromir Velev24 Oct
    • mysql + LVSWinn Johnston24 Jul
      • RE: mysql + LVSJimmy Guerrero24 Jul
        • RE: mysql + LVSWinn Johnston25 Jul
          • RE: mysql + LVS highjacked (mysql + NFS ramfs)Winn Johnston25 Jul
            • RE: mysql + LVS highjacked (mysql + NFS ramfs)Barry Newton25 Jul
  • Re: sum of time?SGreen24 Oct
    • Re: sum of time?Martijn Tonies24 Oct
      • Re: sum of time?Michael Stassen24 Oct
        • Re: sum of time?Michael Stassen24 Oct
    • Re: sum of time?Martijn Tonies24 Oct
    • Re: sum of time?Martijn Tonies24 Oct
      • Re: sum of time?SGreen24 Oct
        • Re: sum of time?jabbott24 Oct