On Thu, 8 Oct 2009, Pavel Ivanov wrote: > And the main problem: SQLite doesn't have such type as date. All types > it supports are listed here: http://www.sqlite.org/datatype3.html.
Pavel, We can use DATE, TIME, and DATETIME column types; they all have TEXT storage class. > Bottom line: change the way you store your dates if you really want to > compare them in sql statements. 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. Thanks, Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users