[C M <[email protected]>] > For example, the average I'd > want from these three timestamps: > > '2012-02-18 22:00:00.000000' > '2012-02-19 23:00:00.000000' > '2012-02-28 01:00:00.000000' > > Should be 11:20pm, as they are all within a few hours of each other at > night. I have not been able to find a query that produces this.
Sounds like you need to convert these timestamps into unix time (seconds since Jan 1 1970), calculate the average, then convert it back to its original format. -- Steinar _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
