On 2/10/2011 5:17 PM, fearless_fool wrote:
> 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;
select date('2011-02-05 21:42:20', units.digit || ' days') as d from
digits as units;
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
