I'd like to write a query that generates ten consecutive days starting at "2011-02-05" (for example), but I believe I'm having trouble with quoting. Assume I have a table of ten digits such as:
CREATE TABLE "digits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "digit" integer) INSERT INTO "digits" ("digit") VALUES (0) INSERT INTO "digits" ("digit") VALUES (1) INSERT INTO "digits" ("digit") VALUES (2) INSERT INTO "digits" ("digit") VALUES (3) INSERT INTO "digits" ("digit") VALUES (4) INSERT INTO "digits" ("digit") VALUES (5) INSERT INTO "digits" ("digit") VALUES (6) INSERT INTO "digits" ("digit") VALUES (7) INSERT INTO "digits" ("digit") VALUES (8) INSERT INTO "digits" ("digit") VALUES (9) A query that does NOT work is: sqlite> SELECT DATE("2011-02-05 21:42:20", "units.digit DAY") AS d FROM digits AS units; ... which returns ten blank records. Using units.digit as the sole argument shows that the counting is working: sqlite> SELECT DATE(units.digit) AS d FROM digits AS units; -4713-11-24 -4713-11-25 -4713-11-26 -4713-11-27 -4713-11-28 -4713-11-29 -4713-11-30 -4713-12-01 -4713-12-02 -4713-12-03 ... but of course I'd like something more current. Is there some obvious quoting that I'm missing? Thanks in advance. - ff PS: I know you can do this with stored functions, but this is a small snippet of a larger system in which a stored function isn't appropriate. -- View this message in context: http://old.nabble.com/generating-mini-calendar%3A-DATE-and-quoting...-tp30896927p30896927.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users