British Columbia, Time Zones, and Postgres | Crunchy Data Blog

▤ Summary

This post explains how British Columbia’s shift to permanent daylight saving time can affect stored timestamps in PostgreSQL. It shows why future appointments can come back with the wrong local time when tzdata changes after data is saved. The article recommends a dual-column design for future local events, with local time and timezone stored alongside a derived UTC value. It also outlines how to recompute affected records when time zone rules change and when plain timestamptz is still the better choice.

▦ Linked Companies