Posted by Jim Michaels on 11/18/01 11:42

SELECT id,name, prj,SUM(TIMEDIFF(end_time,start_time)) AS elapsed
FROM work
group by name,prj;

The problem is, I need elapsed in a datetime format, and SUM truncates to
integer hours.

Is there no way to do this?
I just want the group sums as hours, minutes, dats, months, years.

• Next in forum: Re: diff between 2 DATETIMEs, SUMmed & GROUPed BY project
• Prev in forum: Re: $request problem
• Thread view: diff between 2 DATETIMEs, SUMmed & GROUPed BY project

[Reply to this message]