British Columbia, Time Zones, and Postgres

https://www.crunchydata.com/blog/british-columbia-and-time-zone-changes

#HackerNews #BritishColumbia #TimeZones #Postgres #Database #TechNews #CrunchyData

Newfoundland's Unique Half-Hour Time Zone! ⏰

Did you know Newfoundland is the only place in North America with its own half-hour time zone? Newfoundland Standard Time (NST) is UTC-3:30, making it 30 minutes ahead of the rest of Atlantic Canada. This unique offset reflects its distinct geographical position in the Atlantic. #Canada #TimeZones #Newfoundland #NST

https://en.wikipedia.org/wiki/Newfoundland_Time_Zone

Eastern Time: Canada's Most Populous Zone! 🏙️

Eastern Standard Time (EST) at UTC-5 is Canada's most populous time zone, home to major cities like Toronto, Montreal, and Ottawa. It covers most of Ontario and Quebec, plus eastern Nunavut. When Daylight Saving Time is observed, it shifts to Eastern Daylight Time (EDT), keeping busy urban centres in sync. #Canada #TimeZones #EasternCanada #EST

https://en.wikipedia.org/wiki/Time_in_Canada#Eastern_Time_Zone

Niki wondered whether "midnight" is actually the middle of the night and discovered that it pretty much is. I explain that this is because he's in Berlin, which sits very close (only about 6 minutes out) from the solar UTC+1
Read more: https://danq.me/2026/06/10/is-midnight-in-the-middle-of-the-night/

#reply #time #timezones

Yukon's Permanent Daylight Time! ☀️⏰

Yukon made a unique decision in 2020: it permanently switched to what is effectively Pacific Daylight Time, meaning it stays at UTC-7 year-round. No more changing clocks! This aligns it with Mountain Standard Time, offering consistent daylight hours and simplifying life for residents. #Canada #TimeZones #Yukon #NoDST

https://yukon.ca/en/news/yukon-remain-permanent-time

Atlantic Time: Spanning Four Provinces! 🌊

Atlantic Standard Time (AST) covers Nova Scotia, New Brunswick, Prince Edward Island, and a small part of eastern Quebec. At UTC-4, these provinces spring forward for Daylight Saving Time. It's the first full time zone to greet the sunrise in Canada, setting the pace for the rest of the country! #Canada #TimeZones #AtlanticCanada #AST

https://en.wikipedia.org/wiki/Time_in_Canada#Atlantic_Time_Zone

Central Time: Canada's Geographic Heart! ❤️

Central Standard Time (CST) at UTC-6 covers Manitoba and parts of Nunavut. This zone is often considered Canada's geographic heartland. Like most of Canada, it observes Daylight Saving Time, shifting to Central Daylight Time (CDT) in the warmer months. A vast and vital region! #Canada #TimeZones #CentralCanada #CST

https://en.wikipedia.org/wiki/Time_in_Canada#Central_Time_Zone

Central Time: Canada's Geographic Heart! ❤️

Central Standard Time (CST) at UTC-6 covers Manitoba and parts of Nunavut. This zone is often considered Canada's geographic heartland. Like most of Canada, it observes Daylight Saving Time, shifting to Central Daylight Time (CDT) in the warmer months. A vast and vital region! #Canada #TimeZones #CentralCanada #CST

https://en.wikipedia.org/wiki/Time_in_Canada#Central_Time_Zone