British Columbia, Time Zones, and Postgres
Postgrestime zonedatabasestoragequeryBritish ColumbiaUTClocal time
Author: sprawl_
Date: 6/22/2026
Article Summary:
The article discusses the impact of British Columbia's time zone change on Postgres database storage and queries, and proposes a dual-column pattern to store both local time and UTC time.