Opened 4 months ago

Last modified 3 months 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 4 months ago by Sigurd Ljødal

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

comment:2 Changed 3 months ago by Tim Graham

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