On 11/19/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
>
> Jonathan O <[EMAIL PROTECTED]> wrote:
> > 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
>
> I don't understand - do you want an average of two fixed values, or an
> average of values of a particular column across all rows? The statements
> you show don't make any sense at all.
The latter, I was just showing that this didn't work how you specified show
it in the beginning.
>> select strftime('%H:%M:%S', AVG(time_column)) from tablename; <-- Like
this
What does the data in time_column look like?
Currently looks like HH:MM:SS or MM:SS.
> The time data type is how long something takes to finish in HH:MM:SS
> > or MM:SS or similar right?
>
> There is no time data type in SQLite - only strings, numbers, and a set
> of functions to convert between the two. To store time durations, it's
> probably easiest to just store them as integers representing time in
> seconds, and format with strftime whenever you need string
> representation (either in SQLite statement, or in your application
> code).
I think this is the answer I was needing. But how do I convert seconds to
HH:MM:SS?
