Inspired by this question try this for MySQL
from django.db.models import Count
Product.objects.extra(select={'day': 'date( date_created )'}).values('day') \
.annotate(available=Count('date_created'))
Inspired by this question try this for MySQL
from django.db.models import Count
Product.objects.extra(select={'day': 'date( date_created )'}).values('day') \
.annotate(available=Count('date_created'))