On Thu, 12 Sep 2013 14:01:04 +0100 Simon Davies <simon.james.dav...@gmail.com> wrote:
> Why not > SELECT * FROM "entry" WHERE > bankdate >= date('now','start of month') > AND bankdate < date('now','start of month','+1 month') The half-open interval strikes again! :-) --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users