Opened 2 years ago

Closed 2 years ago

Last modified 2 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 Changed 2 years ago by aaugustin

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Resolution set to invalid
  • Status changed from new to 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 in UTC.

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

Last edited 2 years ago by aaugustin (previous) (diff)
Note: See TracTickets for help on using tickets.
Back to Top