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
31023	__second lookup doesn't work on Django 2.2.7.	Ismael Jerez	nobody	"Hi:

I recently update Django from version 1.10 to 2.2.7. 

I have a query filtering like this:

{{{ MyModel.objects.filter(a_datetimefield__second=4).all() }}}

This returns me an empty QuerySet result.

But, If I try something like this just for testing:

{{{ MyModel.objects.filter(a_datetimefield__second_icontains='4').first().a_datetimefield.second }}}

It returns {int} 4 !!!

I tried this too:

{{{ MyModel.objects.filter(a_datetimefield__second_exact=4).all() }}}

And the results is the same (empty QuerySet instance)

Using hour or minute works perfect, it only happens with second attribute.


Thanks in advance,
Ismael."	Bug	closed	Database layer (models, ORM)	2.2	Normal	needsinfo	query, filter, datetimefield, second		Unreviewed	0	0	0	0	0	0