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?
Jonathan

