Simon Slavin <slav...@hearsay.demon.co.uk> wrote: > On 8 Oct 2009, at 9:35pm, Rich Shepard wrote: > >> A closer look tells me that the string format is incorrect for >> SQL. It >> needs to be YYYY-MM-DD rather than D/M/YYYY. That incorrect format >> seems to >> be the problem. > > It can be anything which sorts into the correct order when seen as a > string. So > > YYYYMMDD > YYYY/MM/DD > YYYYMMDDHHMMSS > > will all work. As long as you pick one and keep to it.
But note that SQLite built-in date/time functions handle some of these formats better than others. See http://www.sqlite.org/lang_datefunc.html . This only matters if you need to perform computations on your dates that go beyond simple comparisons. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users