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 <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
