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
