On 14 Sep 2014, at 11:59am, Martin Engelschalk <engelsch...@codeswift.com> wrote:
> you are probably looking for the between-Operator: Open > http://www.sqlite.org/lang_expr.html and search for "The BETWEEN operator" > > inn you case, date BETWEEN '2014-01-01' AND '2014-01-05' By the way, kudos for storing your dates in a format which is subject to ASCII sorting like that. Assuming that '2014-01-05' means the fifth of January and not the first of May. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users