Opened 11 years ago

Closed 11 years ago

Last modified 11 years ago

#20969 closed Bug (invalid)

ValuesQuerySet converts datetimes to UTC

Reported by: jhatch28@… Owned by: nobody
Component: Database layer (models, ORM) Version: 1.4
Severity: Normal Keywords: valuesqueryset datetime
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

According to comment #9619, django doesn't touch the raw data coming from the database. Postgresql returns the datetimes offset to local time as timezone aware to the local offset. However, in contrast to #9619, django gives the datetimes a UTC timezone, and offsets them back to UTC time.

Change History (1)

comment:1 by Aymeric Augustin, 11 years ago

Resolution: → invalid
Status: new → closed

The comments in this tracker aren't normative. Specifically the comments on #9619 predate the timezone support that was introduced in Django 1.4.

You're seeing the expected behavior when settings.USE_TZ = True. Django doesn't offset back to UTC, it gets the values directly on UTC.

Please reopen if you think that Django's behavior is wrong or inconsistent with the documentation.

Version 0, edited 11 years ago by Aymeric Augustin (next)
Note: See TracTickets for help on using tickets.
Back to Top