# British Columbia, Time Zones, and Postgres

DevFeed: [British Columbia, Time Zones, and Postgres](<https://devfeed.tech/articles/british-columbia-time-zones-and-postgres-14479.md>)

Original publisher: [Read original article](<https://www.crunchydata.com/blog/british-columbia-and-time-zone-changes>)

Author: Christopher Winslett

Published: 2026-06-16T12:00:00Z

Content type: tutorial

Language: en

Sources: [CrunchyData Blog](<https://devfeed.tech/sources/crunchydata-blog.md>)

Topics: [DateTime](<https://devfeed.tech/topics/datetime.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Ubuntu](<https://devfeed.tech/topics/ubuntu.md>)

Tags: [postgres](<https://devfeed.tech/tags/postgres.md>), [production-postgres](<https://devfeed.tech/tags/production-postgres.md>), [sql](<https://devfeed.tech/tags/sql.md>), [time](<https://devfeed.tech/tags/time.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [ubuntu](<https://devfeed.tech/tags/ubuntu.md>)

## AI overview

This article explains how British Columbia's permanent move to UTC-7 affects PostgreSQL handling of future appointments and time-zone conversions. It warns that changed time-zone rules or outdated tzdata packages can cause stored appointments to display at the wrong local time.

## Source excerpt

This year, British Column has moved to year-round Pacific Time. How does that affect date data?