"Simon Slavin" wrote...
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.
Thanks. Yes, I have always done that, even in filenames with dates in them.
But, am pretty sure that I read this in the sqlite site somewhere about
storing dates.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
