How British Columbia's Permanent Daylight Time Shift Affects PostgreSQL Date and Timezone Storage

British Columbia's permanent shift to year-round Pacific Daylight Savings Time (UTC-7) starting March 2026 serves as a case study for discussing date and time zone storage in PostgreSQL. The article explores how calendar systems and users think in terms of local "wall clock time"