Opened 13 years ago
Last modified 13 years ago
#17831 closed Bug
Admin's date list filter's "This month/year" and "Today" are incorrect when USE_TZ is set (with the postgres backend). — at Version 1
| Reported by: | Owned by: | nobody | |
|---|---|---|---|
| Component: | contrib.admin | Version: | 1.4-beta-1 |
| Severity: | Release blocker | Keywords: | |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
This may be applicable to other backends, but I'm not sure.
When using USE_TZ the backend connection is set to use UTC. So __year/__month/__day lookup filters will filter where the UTC timestamp has a year/month/day of the lookup value. However, what's really desired is to use the timestamp at the current timezone. For example, the current code when filtering for "today" datetimes which are not in UTC can potentially return a list of matching records where the set of days being displayed is more than one.
Change History (1)
comment:1 by , 13 years ago
| Description: | modified (diff) |
|---|---|
| Severity: | Normal → Release blocker |
Note:
See TracTickets
for help on using tickets.
I haven't been able to review this fully but this seems like a potential release blocker.