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