#17831: Admin's date list filter's "This month/year" and "Today" are incorrect
when
USE_TZ is set (with the postgres backend).
------------------------------------------------+------------------------
Reporter: Glenn Washburn <development@…> | Owner: nobody
Type: Bug | Status: new
Component: contrib.admin | Version: 1.4-beta-1
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
------------------------------------------------+------------------------
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.
--
Ticket URL: <https://code.djangoproject.com/ticket/17831>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
