Changes between Initial Version and Version 1 of Ticket #17831
- Timestamp:
- Mar 4, 2012, 11:01:13 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #17831
- Property Severity Normal → Release blocker
-
Ticket #17831 – Description
initial v1 1 1 This may be applicable to other backends, but I'm not sure. 2 2 3 When using USE_TZ the backend connection is set to use UTC. So __year/__month/__daylookup 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.3 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.