Opened 7 years ago

Closed 6 years ago

#28650 closed New feature (fixed)

Add TruncWeek

Reported by: Sigurd Ljødal Owned by: Sigurd Ljødal
Component: Database layer (models, ORM) Version: dev
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 (3)

comment:1 by Sigurd Ljødal, 7 years ago

Has patch: set
Owner: changed from nobody to Sigurd Ljødal
Status: new → assigned

​PR

comment:2 by Tim Graham, 7 years ago

Patch needs improvement: set
Triage Stage: Unreviewed → Accepted

comment:3 by Tim Graham <timograham@…>, 6 years ago

Resolution: → fixed
Status: assigned → closed

In a455e732:

Fixed #28650 -- Added TruncWeek database function.

Note: See TracTickets for help on using tickets.
Back to Top