On Tue, Mar 23, 2010 at 07:25:56PM +0000, Bernie Reiter wrote:
> I am checking this for Sunday, March 21st 2010, Monday, 22nd March 2010 and
> Tuesday, 23nd March 2010:
>
> Sunday, March 21st 2010: SELECT strftime('%w',2010-03-21); => 6
You need single quotes around the date value.
2010-03-21 == 2010 + -03 + -21 -- surely not what you intended.
Nico
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
