How British Columbia's Permanent Daylight Time Shift Affects PostgreSQL Date and Timezone Storage
By
winsletts
Summary
British Columbia's permanent shift to year-round Pacific Daylight Savings Time (UTC-7) starting March 2026 serves as a case study for discussing date and time zone storage in PostgreSQL. The article explores how calendar systems and users think in terms of local "wall clock time" rather than UTC, and examines the implications for database design when timezone rules change.
Source
Hacker NewsHow British Columbia's Permanent Daylight Time Shift Affects PostgreSQL Date and Timezone Storagecrunchydata.comKey quotes
· 3 pulledOn March 8, 2026, British Columbia moved their clocks to a year-round Pacific Daylight Savings Time.
Going forward, the UTC offset for America/Vancouver timezone is permanently UTC-7.
people using calendar systems think in terms of local time (i.e. wall clock time), and never consider
You might also wanna read
PostgreSQL Releases Security Updates (18.4, 17.10, 16.14, 15.18, 14.23) Fixing 11 Vulnerabilities
The PostgreSQL Global Development Group has released security and bug fix updates for all supported versions of PostgreSQL (18.4, 17.10, 16.
postgresql.org·3d ago
Hackaday Links: Summer Solstice Roundup — June 21, 2026
A brief Hackaday Links roundup noting the summer solstice (June 21, 2026) and its implications for daylight hours, with a lighthearted nod t
hackaday.com·23h agoAustralia’s battery boom enables more than half of new solar output to be shifted beyond daylight hours
Living a Solstice Year: Reflections on Completing Month 1 of a 13-Month, 28-Day Calendar
A personal reflection on adopting a 13-month calendar system where the year begins at the Winter Solstice instead of January 1. The author d
dualisticunity.com·6d ago
Trump pushes for permanent daylight saving time, but passage remains uncertain
The article reports on President Trump's active campaign to make daylight saving time permanent through the Sunshine Protection Act. The pre
briefly.co·17d ago:max_bytes(150000):strip_icc():focal(749x0:751x2)/Utqiagvik-Barrow-Alaska-051126-7c367aef62a34e79b42d22a8d2e4e587.jpg)
Utqiagvik, Alaska, Sees Final Sunrise for 84 Days Due to Midnight Sun Phenomenon
Utqiagvik (formerly Barrow), Alaska — the northernmost city in the United States — has experienced its last sunrise for 84 days due to the "
People.com·1mo agoComments
Sign in to join the conversation.
No comments yet. Be the first.