---
title: "British Columbia, Time Zones, and Postgres"
url: https://daily.dev/posts/british-columbia-time-zones-and-postgres-uiebxsyyj
source_url: https://www.crunchydata.com/blog/british-columbia-and-time-zone-changes
type: article
source: "Crunchy Data"
published: 2026-06-16T16:06:59.888Z
updated: 2026-06-16T16:07:21.763Z
tags: ["postgresql"]
reading_time: 7
upvotes: 0
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# British Columbia, Time Zones, and Postgres

**[Crunchy Data](https://daily.dev/sources/crunchydata)** · 7 min read · 0 upvotes · 0 comments

## Summary

British Columbia's move to permanent Pacific Daylight Time (UTC-7) starting March 2026 creates a real data integrity problem for PostgreSQL users storing future timestamps. The `timestamptz` type stores UTC and reconverts using current timezone rules, so appointments stored before a `tzdata` update will return incorrect local times after the update. A SQL query is provided to check whether your `tzdata` has already been updated. The recommended solution is a dual-column pattern storing the wall-clock local time, the IANA timezone name, and a trigger-computed UTC timestamp separately. This preserves user intent and allows recomputation when timezone rules change. RFC 9557 explicitly does not solve this problem. A remediation checklist is also provided for cases where `tzdata` has already been updated and data may be corrupted.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.crunchydata.com/blog/british-columbia-and-time-zone-changes>

## Similar posts on daily.dev

- [10 best practices for timestamps and time zones in databases](https://daily.dev/posts/10-best-practices-for-timestamps-and-time-zones-in-databases-xhfzsegaw) · Tinybird · 1 upvotes · 0 comments

---

Tags: [#postgresql](https://daily.dev/tags/postgresql)

[View this post on daily.dev](https://daily.dev/posts/british-columbia-time-zones-and-postgres-uiebxsyyj)