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

Reply via email to