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
8931	Queries on datetimefields return incorrect results in mysql	ElliottM	nobody	"In my models, I have a Planet class. One of the fields in Planet is a datetime field called updated. I also have a class called Base that has an o2o to Planet. The Base class also has an FK called ""owner""to the Player class.

When I want to find all the bases whose planets were updated in the last six weeks, I should be able to do the following:


{{{
six_weeks_ago=datetime.datetime.now()-datetime.timedelta(days=7*6)
bases=Base.objects.filter(planet__updated__gt=six_weeks_ago)
}}}

That query returns no results. However, if I further refine the query to get only the bases owned by a particular player, like follows:
{{{
player_bases=bases.filter(owner__id=22064)
}}}

That query returns 18 results, as expected. It think it's pretty obvious that narrowing down the search criteria should reduce the number of results, not increase them, and I know there are Bases that have been updated in the last 6 weeks."		closed	Database layer (models, ORM)	1.0		invalid	datetime mysql query		Unreviewed	0	0	0	0	0	0