使用Django从数据库中选择聚合计算的日期格式

from django.db import models

class MyModel(models.Model):
    date_field = models.DateField()

from django.db.models import Count, TruncDate
from myapp.models import MyModel

MyModel.objects.annotate(day=TruncDate('date_field')).values('day').annotate(count=Count('id'))

from django.db.models import Count, TruncMonth
from myapp.models import MyModel

MyModel.objects.annotate(month=TruncMonth('date_field')).values('month').annotate(count=Count('id'))

from django.db.models import Count, TruncYear
from myapp.models import MyModel

MyModel.objects.annotate(year=TruncYear('date_field')).values('year').annotate(count=Count('id'))