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 a few others)

Very truly,

Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ  08844-1304 ◊ United States
Legal advice from a non-lawyer: “If you are sued, don’t do what the
Supreme Court of New Jersey, its agents, and its officers did.”
http://www.youtube.com/watch?v=iT2hEwBfU1g
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to