[sqlite] Calculating Average Time

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; 1

Re: [sqlite] Calculating Average Time

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' >

Re: [sqlite] Calculating Average Time

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 t