On Sat, Feb 25, 2012 at 8:44 AM, Black, Michael (IS) <michael.bla...@ngc.com > wrote:
> I subtract 12 hours...so any time from 24:00:00 to 12:00:00 will work. > > Time from noon to noon becomes midnight to midnight. Then you just add > the 12 hours back in. > > > > CREATE TABLE tijd(t int(11)); > INSERT INTO "tijd" VALUES('2012-02-25 22:00:00'); > INSERT INTO "tijd" VALUES('2012-02-27 01:00:00'); > INSERT INTO "tijd" VALUES('2012-02-27 23:00:00'); > > > > sqlite> select time(avg(time(t,'-12 hour')+12)*3600,'unixepoch') from > tijd; > 23:20:00 > > > > You may pick an offset other than 12 depending on your data. > Thank you, this should work well for me, and it is good to see how one should write it as an SQLite query. Che _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users