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"
I'm testing with a simple table:
CREATE TABLE fechas (
id integer primary key autoincrement,
fecha numeric not null
);
1|2011-12-01
2|2011-12-02
3|2011-12-03
4|2011-12-04
5|2011-12-05
6|2011-12-06
7|2011-12-07
8|2011-12-08
9|2011-12-09
10|2011-12-10
11|2011-12-11
12|2011-12-12
13|2011-12-13
14|2011-12-14
15|2011-12-15
16|2011-12-16
17|2011-12-17
18|2011-12-18
19|2011-12-19
20|2011-12-20
21|2011-12-21
22|2011-12-22
23|2011-12-23
24|2011-12-24
25|2011-12-25
26|2011-12-26
27|2011-12-27
28|2011-12-28
29|2011-12-29
30|2011-12-30
31|2011-12-31
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
