Django ORM, group by day
django, django-orm, mysql, python
Solution
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'))
Problem
I am trying to group products by DAY, however date_created is a datetime field. ``` Product.objects.values('date_created') \ .annotate(available=Count('available_quantity')) ``` returns: ``` [ {'date_created': datetime.datetime(2012, 4, 14, 13, 3, 6), 'available': 1}, {'date_created': datetime.datetime(2012, 4, 14, 17, 12, 9), 'available': 1}, ... ] ``` I want: ``` [ {'date_created': datetime.datetime(2012, 4, 14), 'available': 2}, ... ] ``` edit: database backend MYSQL