On Mar 12, 2009, at 12:08 AM, jonwood wrote: > Doug Currie-2 wrote: >> >> Note the '/'s >> > > What does this mean? What does DATE('2009-1-1') or DATE('2009/1/1') > return? > Does DATE() simply have no effect whatsoever?
Sorry to be cryptic. sqlite> select date('2009/12/03'); sqlite> select date('2009-12-03'); 2009-12-03 sqlite> The '/'s format is not supported by DATE. See: http://www.sqlite.org/lang_datefunc.html e _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users