#25339: Aggregation and annotation by time period and intervals (by month, week,
day, hour, etc)
-------------------------------------+-------------------------------------
Reporter: malefice | Owner: nobody
Type: New feature | Status: closed
Component: Database layer | Version: 1.8
(models, ORM) | Resolution:
Severity: Normal | worksforme
Keywords: QuerySet.extra | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by akaariai):
I think DateTrunk expression makes perfect sense for Django. It is often
very useful for aggregation for example. Similarly date formatting and
date parsing functions would be useful.
Oracle and PostgreSQL have date truncation methods out of the box, for
sqlite and mysql it seems we have to use some tricks (format first the
date as string '%y-%m-01', and then read that back in as date for month
truncate for example).
--
Ticket URL: <https://code.djangoproject.com/ticket/25339#comment:5>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" 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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/066.536602f9e24b6dcf2bd053ea095fe26a%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
