Opened 7 weeks ago

Last modified 6 weeks ago

#28650 assigned New feature

Add TruncWeek

Reported by: Sigurd Ljødal Owned by: Sigurd Ljødal
Component: Database layer (models, ORM) Version: master
Severity: Normal Keywords: ORM Extract
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: yes
Easy pickings: no UI/UX: no

Description

Add TruncWeek class to truncate date/datetime fields to midnight at the monday of the week. This is useful to e.g. group values by week.

from django.db.models.functions import TruncWeek

SomeModel.objects.annotate(
    monday_of_week=TruncWeek('some_date'),
).values(
    'monday_of_week',
).annotate(
    sum=Sum('some_field'),
)

Change History (2)

comment:1 Changed 7 weeks ago by Sigurd Ljødal

Has patch: set
Owner: changed from nobody to Sigurd Ljødal
Status: newassigned

comment:2 Changed 6 weeks ago by Tim Graham

Patch needs improvement: set
Triage Stage: UnreviewedAccepted
Note: See TracTickets for help on using tickets.
Back to Top