It would be great if there was a way within the standard Queryset api to
annotate ranges of dates. The use case is that it would remove the need to
resort to RawSQL when grouping things by date ranges, such as the day of
the month. I know the postgres extras package has a DateRangeField, but
it's surprisingly difficult to do this dynamically.
So I'd propose something like this:
queryset.annotate(day_created=DateRange('day', 'created_date'))
Which for Postgres would equate to:
SELECT date_trunc('day', "created_date") as day_created from ...
Is there a technical reason why this hasn't already been done? Or has there
not been much of a need for it?
--
You received this message because you are subscribed to the Google Groups
"Django developers (Contributions to Django itself)" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-developers.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-developers/fe7dcfc9-cbb5-439b-bf08-f45e854a99c6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
