Opened 66 minutes ago

#37137 new Cleanup/optimization

Replace raw SQL suggestion in TIME_ZONE docs

Reported by: Jacob Walls Owned by:
Component: Documentation Version: dev
Severity: Normal Keywords: postgresql, timezone
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Our docs counsel avoiding raw SQL usage where the ORM can do. We have old advice in the TIME_ZONE setting advising to use "raw SQL" when local time conversions are needed. I think instead we should suggest using a lightweight Func wrapping ​timezone() to accomplish the same thing:

​Current text:

  Consider converting to local time explicitly with ``AT TIME ZONE`` in raw SQL
  queries instead of setting the ``TIME_ZONE`` option.

Change History (0)

Note: See TracTickets for help on using tickets.
Back to Top