select * from TABLE where DATE between date('now','-7 days','Weekday 0')
and date('now','-7 days','Weekday 6');
Let me try this:
select * from TABLE where DATE between date('now','-6 days','Weekday 0')
and date('now','Weekday 6');
or compare week numbers (%W specification) [slower]
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
