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;
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
