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
8416	Using Sqlite as database backend causes list_filter and date_hierarchy misbehave in Admin pages	amiroff	nobody	"list_filter and date_hierarchy in Admin do not work properly when using Sqlite as a db backend and filtering by DateField / DateTimeField field types.

To see the bug in action:

1. Create a Django project and an app

2  Set sqlite as db backend

3. Create a test model with DateTimeField

4. Sync the database

5. Add some entries.

6. Observe how clicking ""Today"" or ""This month"" does not reveal the entries that were just created.

7. Also, date_hierarchy behaves wierd too, displaying Current month's name and returning no results when clicked.



I came across this bug while following the official tutorial at http://www.djangoproject.com/documentation/tutorial01/

Switching to Mysql as a db backend solves the problem.

Software:
Using latest (1.0-beta_1-SVN-8437) SVN checkout
Python 2.5.2
Sqlite bundled with Python 2.5.2
Windows XP Pro SP2"		closed	Core (Management commands)	dev		duplicate		amiroff@…	Accepted	0	0	0	0	0	0