On Sat, Feb 25, 2012 at 8:44 AM, Black, Michael (IS) <[email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
