Nando <fl446...@gmail.com> wrote: > I just realized that the "weekday" is not working as and believed, but is > much easier. I can make simple queries of the form: > > select * from dates WHERE date = date ('2011-12-09 ',' weekday 5 '); > > Or > > select * from dates WHERE date <= date ('2011-12-04 ',' weekday 6 '); > > And they work properly. But I can not use this selection criterion with > periods defined by the operator "between" using "X> = Y and X <= Z"
You can. But you have to carefully ensure that, in fact, Y <= Z. Otherwise the condition won't hold for any X. In your original post, you ended up with Y > Z. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users