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
24189	Filtering by month or day doesn't work with MySQL	Unai Zalakain	nobody	"While filtering by year works, filtering by month or by date doesn't:

{{{
    In [1]: from planner.tasks.models import KeyDate
     
    In [2]: KeyDate.objects.all()
    Out[2]: [<KeyDate: Revision>, <KeyDate: Production>]
     
    In [3]: KeyDate.objects.all()[0].date
    Out[3]: datetime.datetime(2015, 1, 20, 14, 1, 20, tzinfo=<UTC>)
     
    In [4]: KeyDate.objects.filter(date__year=2015)
    Out[4]: [<KeyDate: Revision>, <KeyDate: Production>]
     
    In [5]: KeyDate.objects.filter(date__month=1)
    Out[5]: []
}}}

If I switch to SQLite everything works as expected."	Bug	closed	Database layer (models, ORM)	1.7	Normal	invalid	datetime, timezone, date, month, day		Unreviewed	0	0	0	0	0	0