Avoid Timezone Traps: Correctly Extracting Date/Time Subfields in Django with PostgreSQL
When extracting date subfields in Django with PostgreSQL, avoid applying AT TIME ZONE to DATE types under UTC session to prevent offset-based year miscalculations.
Avoiding Timezone Traps: Correctly Extracting Date/Time Subfields in Django with PostgreSQL | Caktus Group
Learn to avoid a common timezone pitfall in Django and PostgreSQL. See why using EXTRACT with AT TIME ZONE on a date type can lead to incorrect res...
