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@strippedhttp://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
>
> --

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.