←back to thread

Debian 13, Postgres, and the US/* time zones

(rachelbythebay.com)
283 points move-on-by | 3 comments | 12 Sep 25 02:33 UTC | HN request time: 0s | source
Show context
yellers ◴[12 Sep 25 08:30 UTC] No.45219992[source]▶
Hang on a second, "(...) in 2023. US/* was moved to tzdata-legacy (...)"

US/* was moved to 'backward' (the file for backward compatibility) in the tz database in 1993(!) and as such was essentially marked as deprecated long enough. https://data.iana.org/time-zones/tzdb/backward

You're telling me you didn't notice ? It was on display in the bottom of a locked filing cabinet stuck in a disused lavatory with a sign on the door saying ‘Beware of the Leopard.

replies(3): >>45220141 #>>45221442 #>>45222056 #
cpburns2009 ◴[12 Sep 25 13:42 UTC] No.45222056[source]▶
Why are time-zones even prefixed by continent? Country-prefixed time-zones make more sense because they're defined politically.
replies(3): >>45222162 #>>45222176 #>>45222885 #
1. hnuser123456 ◴[12 Sep 25 13:52 UTC] No.45222176[source]▶
I disagree. Country borders can move. I have not heard of a city moving between continents however.
replies(2): >>45228339 #>>45236662 #
2. yellers ◴[13 Sep 25 00:50 UTC] No.45228339[source]▶
Istanbul does so all the time. Or never. #schrödinger
3. skissane ◴[14 Sep 25 01:26 UTC] No.45236662[source]▶
> I have not heard of a city moving between continents however.

Continents are conventional are there are multiple competing conventions. The same place absolutely can and will move continents if you decide to swap out one of those conventions for another.

Or consider Cyprus-traditional geography assigns it to Asia-it may be an island, but that’s the nearest continental landmass-and so IANA tzdata lists it as Asia/Nicosia-but since it (or at least the internationally recognised part of it) is in the EU, a lot of people view it as part of Europe. And the standard name for its time zone is “Eastern European Time”