id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 14016 SQLite3 problem with date comparison anonymous tzulberti "I've hit a bug using Django 1.2.1. I've a model with date types. Django generates a query like this that returns the correct results: SELECT xxx FROM ""table"" WHERE (""table"".""pub_date"" >= 2010-01-24 ); If I switch to ""lt"" or ""lte"" it gives me nothing, because sqlite seems to want ""'"" around the date. You can see for yourself in the following test case run with SQLite 3.6.16 and 3.7.0. +++++++++++++++++++++++++++++++++++++++++++++++++++++++ $ sqlite3 prova.db[[BR]] SQLite version 3.6.16[[BR]] Enter "".help"" for instructions[[BR]] Enter SQL statements terminated with a "";""[[BR]] sqlite> create table foo( d date null);[[BR]] sqlite> insert into foo(d) values( '2009-09-09' );[[BR]] sqlite> select * from foo where (d >= 2007-01-01);[[BR]] 2009-09-09[[BR]] sqlite> select * from foo where (d <= 2010-01-01);[[BR]] sqlite> select * from foo where (d <= '2010-01-01');[[BR]] 2009-09-09[[BR]] sqlite> [[BR]] +++++++++++++++++++++++++++++++++++++++++++++++++++++++ $ sqlite3 prova.db[[BR]] SQLite version 3.7.0[[BR]] Enter "".help"" for instructions[[BR]] Enter SQL statements terminated with a "";""[[BR]] sqlite> create table foo( d date null);[[BR]] sqlite> insert into foo(d) values( '2009-09-09' );[[BR]] sqlite> select * from foo where (d >= 2007-01-01);[[BR]] 2009-09-09[[BR]] sqlite> select * from foo where (d <= 2010-01-01);[[BR]] sqlite> select * from foo where (d <= '2010-01-01');[[BR]] 2009-09-09[[BR]] sqlite> [[BR]] " closed Database layer (models, ORM) 1.2 worksforme sqlite, date comparison Unreviewed 0 0 0 0 0 0