Simon Slavin <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
