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