On Tue, Mar 23, 2010 at 12:25 PM, Bernie Reiter
<bernie_on_the_road_ag...@yahoo.co.uk> wrote:
> Dear Dr. Hipp,
> SELECT strftime('%w',2010-03-22 22:12:40) ; => SQL error near "22": syntax
> error
Add quotes:
SELECT strftime('%w','2010-03-22 22:12:40');
See the section Examples at http://www.sqlite.org/lang_datefunc.html
Stephan
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Stephan Wehner
-> http://stephan.sugarmotor.org (blog and homepage)
-> http://loggingit.com
-> http://www.thrackle.org
-> http://www.buckmaster.ca
-> http://www.trafficlife.com
-> http://stephansmap.org -- http://blog.stephansmap.org
-> http://twitter.com/stephanwehner / @stephanwehner
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
