Opened 10 months ago

Closed 6 months ago

#28650 closed New feature (fixed)

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 (3)

comment:1 Changed 10 months ago by Sigurd Ljødal

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

comment:2 Changed 9 months ago by Tim Graham

Patch needs improvement: set
Triage Stage: UnreviewedAccepted

comment:3 Changed 6 months ago by Tim Graham <timograham@…>

Resolution: fixed
Status: assignedclosed

In a455e732:

Fixed #28650 -- Added TruncWeek database function.

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