Django: Sum on an date attribute grouped by month/year
- by Sébastien Piquemal
Hello,
I'd like to put this query from SQL to Django:
"select date_format(date, '%Y-%m') as month, sum(quantity) as hours from hourentries group by date_format(date, '%Y-%m') order by date;"
The part that causes problem is to group by month when aggregating. I tried this (which seemed logical), but it didn't work :
HourEntries.objects.order_by("date").values("date__month").aggregate(Sum("quantity"))
