On 11/19/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
>
> Jonathan O <[EMAIL PROTECTED]> wrote:
> > I have searched (archives/google) and haven't found a solution for
> > what I need and can't think of a solution so below is my question.
> > I have:
> > Job 1 run 1 with a time of '01:00:15'
> > Job 1 run 2 with a time of '01:00:21'
> >
> > What I do is:
> >
> > select sum(strftime('%H%M%S', time_column))/2 from table;
> > 10018
>
> You probably want
>
> select strftime('%H:%M:%S', AVG(time_column)) from tablename;
Doesn't seem that way.
select strftime('%H:%M:%S', avg('01:00:15' + '01:00:21')/2;
12:00:00
The time data type is how long something takes to finish in HH:MM:SS or
MM:SS or similar right?
