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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users