Skip to content
Snippets Groups Projects
  1. Nov 22, 2021
  2. Oct 29, 2021
  3. Oct 28, 2021
  4. Oct 27, 2021
    • Nicolas Dandrimont's avatar
      grab_next_visits: avoid time interval calculations in PostgreSQL · 0c7ef27b
      Nicolas Dandrimont authored
      When the database is in a non-UTC timezone with DST, and a `timestamptz
      - interval` calculation crosses a DST change, the result of the
      calculation can be one hour off from the expected value:
      
      PostgreSQL will vary the timestamp by the amount of days in the
      interval, and will keep the same (local) time, which will be offset by
      an hour because of the DST change.
      
      Doing the datetime +- timedelta calculations in Python instead of
      PostgreSQL avoids this caveat altogether.
      0c7ef27b
  5. Oct 22, 2021
  6. Oct 20, 2021
  7. Oct 18, 2021
  8. Oct 15, 2021
  9. Sep 02, 2021
  10. Aug 27, 2021
  11. Aug 26, 2021
Loading