On Thu, Feb 10, 2011 at 05:27:02PM -0500, Samuel Adam scratched on the wall: > On Thu, 10 Feb 2011 17:17:29 -0500, fearless_fool <rdp...@gmail.com> wrote: > > [snip] > > 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; > > http://www.sqlite.org/lang_datefunc.html > > http://www.sqlite.org/lang_select.html
...and quote your strings correctly. SQL string literals (such as the two in this select) use ('). (") is reserved for labels (table names and column names). -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users