On 11/19/07, P Kishor <[EMAIL PROTECTED]> wrote:
>
> On Nov 19, 2007 5:43 PM, 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
> >
> > But I don't know how to get it back into a time format. Is there an
> easier
> > way?
> >
>
>
> SELECT AVG(strftime('%H', time_column)*3600+strftime('%M',
> time_column)*60+strftime('%S', time_column)) FROM table;
>
This returns the same value as I get but in seconds. I want '01:00:18'.
