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
33075	'__date' returns None in MySQL while it returns date object in Sqlite3	pikicode	nobody	"database: mysql 5.7
django version: 3.2
python version: 3.8.1


{{{Model.objects.values('some_datetime_field__date',) }}} returns None in MYSQL
    


{{{
class Inbound(models.Model):
    effective_date = models.DateTimeField(null=False, blank=True)
    number = models.IntegerField()
    # other fields.

daily_changes = Inbound.objects.all().values('effective_date__date')\
  .annotate(total_change=Sum('number')).
Inbound.objects.values('effective_date__date')
}}}




The code just returns Nones in Mysql. But it returns date object with Sqlite"	Bug	closed	Database layer (models, ORM)	3.2	Normal	invalid	mysql		Unreviewed	0	0	0	0	0	0