Opened 15 years ago
Closed 11 years ago
#12489 closed New feature (fixed)
Need a Field Lookup for day of year: __dayofyear
Description ¶
The current built-in year, month, day, week_day Field Lookups do not directly help if you need to find rows that are on a specific date. In SQL, there is a DAYOFYEAR(). It would be useful to have a Field Lookup that pairs this function with python datetime's %j directive
Change History (14)
comment:1 by , 15 years ago
| Triage Stage: | Unreviewed → Accepted |
|---|---|
| Version: | 1.1 |
comment:2 by , 14 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:3 by , 14 years ago
| Has patch: | set |
|---|
comment:4 by , 14 years ago
| Needs documentation: | set |
|---|
comment:5 by , 14 years ago
| Needs documentation: | unset |
|---|
comment:6 by , 14 years ago
| milestone: | → 1.3 |
|---|
comment:7 by , 14 years ago
| milestone: | 1.3 → 1.4 |
|---|
This is a feature addition, and the deadline for new features in 1.3 passed some time ago.
by , 14 years ago
| Attachment: | django12489.diff added |
|---|
Implemented day_of_year & week_of_year with tests
comment:8 by , 14 years ago
| Severity: | → Normal |
|---|---|
| Type: | → New feature |
comment:9 by , 14 years ago
| Easy pickings: | unset |
|---|---|
| Needs documentation: | set |
comment:12 by , 11 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
The custom lookups introduced in Django 1.7 can be used to implement this feature.
See https://docs.djangoproject.com/en/1.7/ref/models/custom-lookups/
Note:
See TracTickets
for help on using tickets.
DAY_OF_YEAR is starting to get a bit esoteric, but I can't see any harm providing it, along with it's analogs WEEK and WEEK_OF_YEAR.
Related: #8424 describes adding HOUR/MINUTE/SECOND filters.