On Nov 19, 2007, at 10:59 PM, Igor Tandetnik wrote:
Jonathan O <[EMAIL PROTECTED]> wrote:
On 11/19/07, Igor Tandetnik <[EMAIL PROTECTED]>
wrote:
What does the data in time_column look like?
Currently looks like HH:MM:SS or MM:SS.
The latter is going to cause difficulties - SQLite's date/time
functions are going to interpret it as HH:MM with seconds omitted.
If you insist on storing strings, normalize them all to HH:MM:SS
format. Then you can do something like this:
select time(AVG(strftime('%s', time_column)) / 86400.0 - 0.5)
from tablename;
I was trying to figure out how this worked and came up with a better
solution:
select time(avg(strftime('%s',time_column)), 'unixepoch') from
tablename;
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
