A fork for the time-zone database?
A controversy about the handling of the Time Zone Database (tzdb) has been brewing since May, but has come to a head in recent weeks. Changes that were proposed to simplify the main database file have some consequences in terms of time-zone history and changes to the representation of some zones. Those changes have upset a number of users of the database—to the point where some have called for a fork. A September 25 release of tzdb with some, but not all, of the changes seems unlikely to resolve the conflict.
The time-zone database is meant to track time-zone information worldwide for time periods starting at the Unix epoch of January 1, 1970. But, over the years, it has accumulated a lot of data on time zones and policies (e.g. daylight savings time) going back many years before the epoch. As with anything that governments and politicians get involved with, which time zone a country (or part of a larger country) is in, whether it participates in daylight savings time (DST), and when the DST switches are made, are arbitrary and subject to change, seemingly at whim. Tzdb has been keeping up with these changes so that computer programs can handle time correctly since 1986 or so, when it was often called the "Olson database" after its founder, Arthur David Olson.
Merging time zones
Back in May, tzdb maintainer Paul Eggert proposed two changes, one of which was winnowed out during the discussion. The other was to merge zones (identified by location strings, such as "Europe/Berlin") that have the same post-1970 history under a single name. The entries that got merged out would be maintained as links to the merged zone and their pre-1970 history would be moved into the backzone file that is also distributed with the database. Which zone name would be the "winner" is based on the rules embodied in the tzdb theory document; the most populous choice would be the main zone, while the others would be relegated to the status of links.
The maintainer of the Joda-Time library for date and time handling in Java, Stephen Colebourne, disagreed strongly with the change and asked that it be reverted. One of the main problems is that programs using tzdb and looking at pre-1970 dates for places that lost out in the merge will get incorrect time-zone information. The pre-1970 time-zone information for those regions will, effectively, be lost, he said:
[...] many places (eg Anguilla, Antigua and Aruba) are now sharing time-zone history, and that history is **from some other zone**. That seems completely unacceptable.While I understand the motivation to remove the burden of pre-1970, that cannot come at the cost of giving a place the history of somewhere completely different.
In another message, he pointed out other problems that he saw with the changes, which are partly political in nature:
For example, Norway's and Sweden's time zone history is being wiped out in favour of that of Germany. Can no-one here see the political sensitivity in that?This has a very serious impact on Joda-Time because it normalizes time-zone IDs. (It treats a Link as the key to the normalization, so anything at the weak end of a Link is replaced by the ID at the strong end. You might complain that it shouldn't do that, but it has operated that way for 20 years...)
This code:
DateTimeZone zone = DateTimeZone.forID("Europe/Stockholm"); System.out.println(zone);will print "Europe/Berlin" if this change is not reverted. I consider this to be catastrophic.
Since Berlin and Stockholm (Oslo, also, as mentioned elsewhere) share the same post-1970 time-zone history, they would all get merged under "Europe/Berlin" as Berlin is the most populous. The pre-1970 history for those countries (Sweden and Norway) would get moved to the backzone file; the data is still available, but many applications have gotten used to getting accurate historical information without consulting backzone. For his part, Eggert is trying to solve an unfairness problem within the database:
Why should we maintain Norway and Sweden's time zone histories, when we don't maintain the histories for Guangdong, KwaZulu-Natal, Thanh Hóa, or Uttar Pradesh? Aside from politics, these regions are similar: although all the regions have distinct timestamp histories with data that I can cite, all the regions can be merged into other tzdb regions (Norway into Berlin, Guangdong into Shanghai, etc.) if we consistently limit tzdb's scope to regions that differ after 1970. Given all that, why should Norway and Sweden continue to be special?These are not particularly-obscure examples, as Guangdong etc. all have more people than Norway or Sweden do. It would be political to continue to focus on Norway and Sweden while excluding Guangdong etc. purely for reasons unrelated to timekeeping.
He also pointed out that Joda-Time already has to deal with these kinds of
merges; earlier releases, including the 2021a release from
January, have merged zones. "Whatever techniques people use for these
longstanding links
should also
work for the new links.
" Eggert is convinced
that he is solving a real problem here:
The current patch was not prompted by purism. It was prompted by a complaint from a user who made a good point about the politics of tzdb 2021a, which can reasonably be interpreted to favor countries like Norway etc. over countries like Kosovo etc. Rejecting this kind of complaint and saying "we've always done it that way" is not a promising path forward.
While he believes that users will not really be affected by the changes and that the merge process (which has been ongoing for a number of years in a slower, less-visible manner) is working well, some disagreed. Derick Rethans, who maintains the date and time handling for PHP, Hack, and MongoDB, said that the cleanups are making things worse, in part because they ignore backward compatibility. Colebourne was even more blunt:
Let me be clear - this change cannot stand. The reliability of TZDB has declined considerably over the past few years, but it is time to say enough is enough. This is where the line in the sand needs to be drawn.
Part of the problem is that currently backzone has a fair amount of poor quality data that got shifted out of the main database long ago for that reason. Moving well-researched historical data into that file (for, say, Sweden) makes it difficult to distinguish the two. Eggert said that, currently, the database can be built either with or without the backzone data, but it's an all-or-nothing choice; that could perhaps change moving forward:
For example, if a downstream user wants the 'backzone' entry for Europe/Stockholm which is well-documented, but doesn't want backzone's America/Montreal entry because it's not well-attested and is most likely wrong, the user could specify a list of backzone names that includes Europe/Stockholm but excludes America/Montreal. I think it would not be too much work to add something like this to the tzdb code.
A problem with that approach is that applications may just generally consult whatever tzdb the operating system has installed. Today that means they will get proper time-zone information for, say, Norway on pre-1970 dates, but down the road they would not, unless the operating system builds a version including some of the data from backzone. Different choices of exactly which data to include could easily create incompatibilities between systems for pre-1970 dates.
Charter breach?
On June 3, Colebourne formally
requested a reversion of the time-zone merging because he said it
breached the RFC 6557
charter. For one thing, the TZ Coordinator (i.e. Eggert) "has
not taken into account the views of the mailing list
" as required by
the charter. Furthermore, the cleanups are not within the scope of the
charter, he said.
Multiple people spoke up in support of Colebourne's message, though not all of them agreed that Eggert's plans were a breach of the charter. The clear consensus in that thread, though, was that the changes should be reverted so that some other solution could be found. Maintainers of the date and time code for multiple projects were opposed to the changes, though perhaps not as an official position of the project, at least yet. While the backzone was mentioned, it is not truly a workable solution for projects like PostgreSQL, as pointed out by Tom Lane:
However, the Postgres project is finding itself in a hard place precisely because we *didn't* adopt backzone. We reasoned that the default set of zones was the preferred thing and thus would be the most likely to remain stable. Now, not only is the default different (which perhaps we could live with), but there's no way at all to get the old default. That's not okay, and it seems to me to fly in the face of most understandings of software backwards compatibility, never mind any tzdb-specific rules.
Eggert did not directly address the breach claim, but a few days later posted a compromise idea that would provide a build flag to create the database in two different ways: as it was before the merges and as it is with them. But the question then becomes: which is the default? Many applications do not build the database, but use it as distributed in the tarfile, Colebourne said. Eggert was not opposed to providing an alternate tarfile, but did not seem inclined to revert the merges that he proposed.
On the other hand, Colebourne and seemingly everyone else participating in
the thread are willing to work on some kind of technical solution that
solves the problems, but think that the current merges should be reverted
first. There are ways to derive the two different views into the data, Colebourne
said,
but that requires keeping the existing data in the main database file.
That file can be processed to automatically do the merges as Eggert wants, but that the
reverse is not true, Colebourne said. In another message,
he described the situation as an impasse, saying that there had been many
requests for reversion and "no requests to retain it
".
There are technical solutions available to reduce the amount of data published to downstream users, but the starting point must be a fully populated database, not one that is logically broken. The next action must be to revert. Then we can agree on any technical measures necessary.
Colebourne started a thread on what data tzdb should contain. It described the kinds of data present in the database, how they are used, and the problems that need to be addressed with them. It offered up a proposal based on his plan to automatically process the file to create the merges for regions that share post-1970 history, but to retain the existing data so that pre-1970 history did not move to backzone. The proposal was received positively, though there was some constructive criticism; Eggert did not really participate in that thread, however.
Samoa
For a few months, that is where things stood. The development version of tzdb had the merges Eggert proposed, along with various other fixes made along the way. On September 13, Eggert said that a new release was not imminent in response to a query about the status of the merge changes. But, then, along came Samoa.
On September 20, Geoffrey D. Bennett posted
a notice that on September 15 Samoa had decided
to stop switching to daylight savings time. That meant that tzdb needed to
change to reflect that—and before the September 26 DST-switch date.
As Eggert put
it: "That's not much notice
".
Later that day, Colebourne posted
"Preparing to fork tzdb
". The imminent release that seemed
likely to contain those changes meant that a fork was needed in order to
maintain the zones as they are in the 2021a release, he said. He would
prefer that Eggert revert the changes, but:
In the event that the tzdb maintainer does not revert, consideration must be given to forking the project. The purpose of the fork would initially be to maintain the tzdb data set as it was prior to the dispute. This would then be released in parallel to the original tzdb to ensure that downstream projects do not each do their own thing (ie. to minimize incompatibilities downstream).
Colebourne asked if there was support for such a fork and whether there were people or organizations willing to assist. For the most part, the reaction to the idea of a fork was unfavorable; there were exceptions (Lane and Rethans, for example). Eliot Lear noted several downsides, including confusion among users and implementers, as well as fragmentation of expertise between the two. He suggested proposing changes to RFC 6557 as a way forward. In a somewhat similar vein, Emily Crandall Fleischman suggested invoking the procedure to replace the coordinator as a better alternative than a fork.
Eggert said that the fork would be discriminatory and that it would take a lot of work to fix the fork:
Such a fork would arbitrarily discriminate against countries like Angola and Niger, and in favor of countries like Norway and Sweden.A primary goal of the recent patches was to avoid racial or national preferences that were present in the previous setup. Arguably these preferences were not intentional, or were apparent and not real; however, that's not an argument I would want to defend.
He suggested working together on technical solutions to resolve the
problems that stem from the changes. He also objected to the idea that the
data was getting "wiped out
" by the changes. But, as Lane pointed
out, including the backzone data "does *not* reproduce
what was formerly the
default set of zones
". He said that it might be technically correct
to argue that the data is not going away, but that does not really reflect
the reality of the situation:
I'm all for improving equity in tzdb's coverage, but I think it should be done by adding coverage for underserved areas, not removing data from areas that had been well-covered. And let's make no mistake: removing data from the default build is removing data, for many downstream users who won't have an opportunity to make their own decisions about what their platforms provide.
Colebourne renewed his call for a reversion. Like Lane, he believes that adding more data is the solution to the problem, but another possibility would be to remove all pre-1970 data from tzdb by moving it to backzone. In the meantime, the path forward is clear in his mind:
The *only* good faith move you can make right now is to revert the patch. I'm quite happy to discuss practical solutions once that is done. If 2021b is released with the disputed patch then the fork will occur, and you as TZ coordinator will have directly caused the fork.
As suggested, Colebourne also polled the list to see if there was a consensus that a change to the coordinator is needed. The results of that were a resounding "no", which he acknowledged in the thread. His June appeal to the Internet Engineering Steering Group (IESG) about a breach in the charter was answered on September 22. Murray S. Kucherawy said that he disagreed with Colebourne's arguments, though that is not necessarily the final answer if he wishes to pursue it further. Colebourne said that both of the formal options for relief had been tried and failed:
The potential options remaining are to fork the project or to solve the issue. For the avoidance of doubt, my preferred option would be to solve the issue.
He noted that there was strong support for the idea of releasing 2021b with just the minimal changes needed to support the Samoa change, then taking a week or so to calm everything down and start to work on other solutions. He asked Eggert if he would do so, but it is perhaps not surprising that Eggert declined. He is concerned that the discrimination problems are now more visible because of the dispute, so he needs to act now:
Unfortunately, the equity issue has broadened and is now visible outside our little community, and I really and sincerely doubt whether it'd be a good idea for us to do nothing about it now. We need to establish that we are fixing the problem and are not deferring action to a never-never land of arcane bureaucracy, and we need to do so in terms that will be clear to outsiders.
He did compromise to some extent by proposing to only merge nine zones for 2021b, rather than the 30+ he proposed to begin with. That would provide evidence that progress is being made, while avoiding the biggest problem area:
[...] the idea is to revert most (but not all) of the objected-to changes. In particular, this will revert the changes to Europe/Oslo and Europe/Stockholm, which have drawn the most objections. The idea is to take the first step now, and to take more steps in future releases (which should not be distant-future releases, as we need to continue to make and exhibit a good-faith effort to fix the problem).
That was not acceptable to Colebourne, again unsurprisingly. But meanwhile, the clock was ticking. Other proposals were made; Russ Allbery wanted to reframe the debate by changing the "naming layer", while Lane tried to find a way to maintain the existing set of zones (and all of their historical data) going forward. Colebourne summarized the whole issue regarding pre-1970 data, while attempting to be even-handed; that led to yet another enormous thread, though he asked that only actual corrections be posted. He also put out a lengthy blog post about the dispute.
2021b release
On September 25, Eggert released version 2021b of tzdb with the merges of nine zones as his amended proposal indicated. He followed up the release announcement with a justification for the release and the choices made in it. Eggert simply sees the 30+ changes he proposed in May as the endgame for a process that started in 2013, though he did acknowledge problems with making changes to so many zones at once, thus the reduction to nine for 2021b.
Historical data is
mostly only used by astrology programs, he said, and it is "typically
grossly inadequate for realistic use outside the named
location
". Tzdb focuses on accurate data for 1970 and beyond; his
efforts to merge zones is part of that. Now that the fairness issue has
come to the fore, it is time to deal with it:
Norway and Sweden have triggered concerns, much more so than similar changes made (for example) to Angola and Congo in tzdb 2014g.[...] It's a bad look for us that so much concern about Norway and Sweden has appeared on this mailing list, even though hardly anybody seems to have cared about Angola and Congo. It'll be an even worse look if we ignore this issue weeks, months or even years after it's been made clear to us.
[...] With all this in mind, issuing 2021b now is a significant step toward equity in tzdb. It will let us say that we are moving toward a fair process, and will give us the opportunity and motivation to improve on that process and to address and balance the various other concerns that have recently appeared on the mailing list.
As might be guessed, Colebourne was very unhappy with the release.
In summary, I am livid with the high-handed approach you have taken wrt the release of 2021b. Despite near unanimity of the mailing list requesting you to release 2021a+MinimalChanges, you progressed 9 out of the 30 link merges based on a rationale that you acknowledge is not universally accepted.
He said that he
would be taking a few days away from the issue, but planned to "start a positive
discussion as to what the next steps can be
" after that.
In his blog post he noted that he would
be looking into alternatives, such as perhaps moving a fork of tzdb under the Unicode
Common
Locale Data Repository (CLDR) project. It turns out that Eggert is
not
opposed to CLDR being involved in some fashion. Perhaps some kind of
compromise can be found in that direction.
The dispute spanned multiple, gigantic threads in May, June, and September. The call to fork tzdb also spawned several heads-up emails to LWN; thanks for those. It is the most visible thing to happen in the normally quiet tzdb arena since the 2011 lawsuit against Olson and subsequently moving tzdb under the Internet Corporation for Assigned Names and Numbers (ICANN) .
It is a little hard to see how users of tzdb are served by making pre-1970 zone information worse for some places, even if those places had been "elevated" in status incorrectly along the way. Dumping that information into the backzone file is tantamount to losing it completely, though the historical record of those moves could be used to reconstruct things. Perhaps a separate "historical tzdb" project is needed that better serves the needs of astrologers and others who have needs for that kind of information. It would be plausible to use the existing tzdb contents as at least a starting point—perhaps more than that.
The timing crunch caused by Samoa's late decision on DST changes was not only disruptive for tzdb, but also for residents of Samoa, as Eggert noted. Two weeks is not a lot of time to get the word out, even outside of the computer realm, but many computers and devices did not magically update to 2021b, so they switched to DST as (previously) scheduled.
It is also unfortunate that the coordinator took the opportunity to lock in these controversial changes on (relatively) short notice over the vehement opposition of some. However inequitable the zone choices in 2021a (and before) were, things had been that way for a long time; disrupting users and developers to create a kind of fait accompli is not a particularly good look either. There are already questions on the mailing list about what distributions and other tzdb users should do with the changes. Taking a bit more time to come up with a scheme that addressed all of the concerns, then making all of the changes at once using that mechanism in a month or two hardly seems burdensome—or unfair—but here we are.
Posted Sep 29, 2021 0:01 UTC (Wed)
by tux3 (subscriber, #101245)
[Link] (10 responses)
The urgency with which the equity issue is being addressed after a long period of status quo seems well-intentioned, but ultimately disruptive enough that downstreams will have needed to delay the change anyways, so it seems upstream could have addressed the 'needing to establish that we are fixing the problem' desire by establishing a deadline for the change, without that deadline necessarily having to coincide with the Samoa change.
I trust the Debian maintainers to save me from unexpected compatibility breakage, but it seems unfortunate that the eventual result here still seems to be sunsetting data of unfairly high quality into a non-default file...
Considering that tz data is not a zero-sum game (unlike, say, allocation of funding), solutions that attempt to improve equity solely by taking away the extra good, without much focus on improving what's lacking, generally feel pretty unsatisfying.
Posted Sep 29, 2021 7:09 UTC (Wed)
by cpitrat (subscriber, #116459)
[Link]
Posted Sep 29, 2021 8:32 UTC (Wed)
by dveeden (subscriber, #120424)
[Link] (6 responses)
Posted Sep 29, 2021 8:54 UTC (Wed)
by nim-nim (subscriber, #34454)
[Link] (4 responses)
It is incredibly offensive to merge different political entities from outside. That some could not defend themselves in the past does not mean others won’t. Moreso because of some (primarily US) political agitation not shared in other countries (which have their own political issues to tackle).
Leveling down has never been a road to success.
Posted Sep 29, 2021 19:07 UTC (Wed)
by fuhchee (guest, #40059)
[Link] (2 responses)
Posted Oct 10, 2021 6:13 UTC (Sun)
by rlhamil (guest, #6472)
[Link] (1 responses)
That would strive for both accuracy and balance; genuine "equity" should not reduce accuracy for anyone.
Posted Oct 10, 2021 17:57 UTC (Sun)
by Wol (subscriber, #4433)
[Link]
Why has he gone for 1970? Okay, that may be the Unix base date, but why is he dragging Unix history into this? Surely the number of people who care about going back to 2010 are pretty much the same as those who care about going back to 1970. By his logic we might as well decide to go back only a decade.
MOST people don't give a monkeys about historic data. Some people need to be able to go back a year or two. Others need to go back as far as possible.
Just make it easy, at the user level, to generate the active database from the master. Then we don't care about detail too much in the active database, but we care strongly about accuracy in the master.
Cheers,
Posted Sep 30, 2021 6:41 UTC (Thu)
by cpitrat (subscriber, #116459)
[Link]
Posted Sep 30, 2021 6:03 UTC (Thu)
by dvdeug (guest, #10998)
[Link]
Posted Sep 30, 2021 6:54 UTC (Thu)
by aurel32 (subscriber, #7059)
[Link] (1 responses)
The problem that distributions are facing is not due to the drop of pre-1970 data, but rather the merge of timezones from different countries, and the impossibility to present users with a list of timezones matching their country. These links between ISO 3166 country code and timezone is progressively removed and the links in "backward" do not provide this information.
Posted Sep 30, 2021 10:12 UTC (Thu)
by LtWorf (subscriber, #124958)
[Link]
So what if now I have to pick Berlin and then in a couple of years sweden changes and does permanent DST? I'll have my account set on berlin and when sweden appears again I'll have a wrong clock?
The fact that they are on the same time today doesn't mean the elected government will not decide it's best to change things.
Posted Sep 29, 2021 0:39 UTC (Wed)
by itsmycpu (guest, #139639)
[Link] (1 responses)
No, independently of whatever happened before or after there or elsewhere, that is not a "bad look" but the healthy and necessary response to a grave mistake (assuming the article comes anywhere close to describing the real situation). It is a good look that this concern exists, even if other concerns are perhaps lacking.
Pre-1970 data is still important (even if not to everyone, as otherwise it could just be removed completely), and you simply cannot take valid data for whole countries away or out of sight, and replace it with invalid data. You cannot even think of doing that as long as there is any other option at all.
Posted Sep 29, 2021 7:12 UTC (Wed)
by cpitrat (subscriber, #116459)
[Link]
Posted Sep 29, 2021 1:11 UTC (Wed)
by felixfix (subscriber, #242)
[Link] (12 responses)
If I have this wrong, apologies. If I don't, well, maybe the maintainer needs to stop trying so hard to solve the world's problems by making everyone equally inferior.
Posted Sep 29, 2021 3:29 UTC (Wed)
by sub2LWN (subscriber, #134200)
[Link] (5 responses)
Just set all clocks to UTC: problem solved, although sunrise might happen at 5 P.M. now (more or less, as this rock keeps wobbling around the Sun) :-)
Posted Sep 29, 2021 3:36 UTC (Wed)
by pbryan (guest, #3438)
[Link]
Posted Sep 29, 2021 10:50 UTC (Wed)
by taladar (subscriber, #68407)
[Link] (3 responses)
Posted Sep 29, 2021 17:58 UTC (Wed)
by sub2LWN (subscriber, #134200)
[Link] (2 responses)
Yes, it wouldn't just be resetting all the clocks in the world: there would be many logs and datasets to convert initially. However, once all dates and timestamps are converted to UTC, "timezone data" ceases to mean anything practical in the present, past, or future: a recorded timestamp was either _the_ universally correct time or not. Not that the histories would be discarded or completely meaningless, but they would become completely academic: history books of legislative trivia, not something you might expect to grapple with during your next automated software update. :-)
And whether the time of events is recorded accurately is the responsibility of whoever maintains the records, not the IANA: if my system clock is incorrect by several years (which does happen from time to time, especially after certain types of power loss), so none of the timestamps on my system happen to be accurate to any reasonable degree despite any political decree, that's only my fault and not visible to any external organization.
Similarly, many "hours of operation" signs would need to be reprinted to account for seasonal variance in opening/closing time of stores, etc., since local "daylight savings" would no longer be achieved by arbitrarily manipulating our timepieces. A store could open at 4 P.M. instead of 5 P.M. (and close at 0 A.M. instead of 1 A.M.) depending on the season.
Posted Sep 29, 2021 19:15 UTC (Wed)
by felixfix (subscriber, #242)
[Link] (1 responses)
Posted Sep 29, 2021 20:07 UTC (Wed)
by sub2LWN (subscriber, #134200)
[Link]
If legislators pass a measure for Universal Time Normalization, there could be legal repercussions for _not_ creating updated versions of official records! (The old ones could be preserved too, to keep a thorough record of their inherent historic inequities.) I'm not very serious about this, but was imagining what a "lowest common denominator" approach to ongoing global timekeeping could be like, and some of the ramifications.
Maybe a media review committee could be tasked with figuring out the best disclaimer to put on copies of films such as High Noon (1952) to caution people against the dangers of localized timekeeping.
Posted Sep 29, 2021 6:03 UTC (Wed)
by epa (subscriber, #39769)
[Link] (2 responses)
Posted Sep 29, 2021 7:15 UTC (Wed)
by cpitrat (subscriber, #116459)
[Link] (1 responses)
Posted Sep 30, 2021 1:22 UTC (Thu)
by devkev (subscriber, #74096)
[Link]
Posted Sep 29, 2021 16:06 UTC (Wed)
by HenrikH (subscriber, #31152)
[Link] (1 responses)
Posted Sep 30, 2021 11:29 UTC (Thu)
by immibis (subscriber, #105511)
[Link]
Posted Sep 29, 2021 19:10 UTC (Wed)
by fuhchee (guest, #40059)
[Link]
Posted Sep 29, 2021 1:35 UTC (Wed)
by itsmycpu (guest, #139639)
[Link] (1 responses)
Posted Sep 30, 2021 10:16 UTC (Thu)
by LtWorf (subscriber, #124958)
[Link]
Posted Sep 29, 2021 4:21 UTC (Wed)
by rsidd (subscriber, #2582)
[Link] (23 responses)
Posted Sep 29, 2021 7:28 UTC (Wed)
by tialaramex (subscriber, #21167)
[Link] (22 responses)
From the looks of it, once again, the tzdb is being held hostage by people who think that what matters is that their astrology program's nonsense output is the "right" nonsense output and it's important that this doesn't change, and too bad if that wastes time and resources for those of us who don't believe in their nonsense.
Plus, apparently Joda Time silently destroys round tripping and its author very much would rather the raw data takes responsibility for concealing this behaviour rather than needing to either persuade their users it's a feature and that's supposed to happen or ship a fix which would be embarrassing.
Posted Sep 29, 2021 8:08 UTC (Wed)
by eru (subscriber, #2753)
[Link] (3 responses)
Posted Sep 29, 2021 11:27 UTC (Wed)
by hmh (subscriber, #3838)
[Link] (2 responses)
But those don't use tzdb at all.
Just use the sha512 to name the files with real contents (object-store like) and have every time zone a symlink farm to them.
If only it was that easy...
Posted Sep 29, 2021 12:45 UTC (Wed)
by eru (subscriber, #2753)
[Link]
OK, on very small systems it matters, but then you don't use the TZ database at all. On a bit larger systems that can support the database, it is unlikely to matter very much whether the size is 3 Mb or 5 Mb.
I like your suggestion about how the compiled data should be stored. It automatically optimizes, if two source time zones happen to be identical in some given version of the database.
Posted Sep 29, 2021 13:12 UTC (Wed)
by PhracturedBlue (subscriber, #4193)
[Link]
Posted Sep 29, 2021 9:12 UTC (Wed)
by nim-nim (subscriber, #34454)
[Link] (6 responses)
For example, if you wanted to analyze past electricity use to design future “smart”, “green” or whatever power grids, you‘d better make sure your past DST info is right as when people go to work or return home changes the whole distribution pattern, (so much that’s why DST was invented in the first place).
More so if you want to cross-check data around areas with different time history.
Posted Sep 29, 2021 11:37 UTC (Wed)
by bluca (subscriber, #118303)
[Link] (2 responses)
Posted Sep 29, 2021 14:53 UTC (Wed)
by nim-nim (subscriber, #34454)
[Link] (1 responses)
Posted Sep 29, 2021 14:55 UTC (Wed)
by nim-nim (subscriber, #34454)
[Link]
Posted Oct 10, 2021 7:53 UTC (Sun)
by ssmith32 (subscriber, #72404)
[Link] (2 responses)
People will still be arriving and leaving at the same time, just in one timezone, which seems much easier to reason about, from the perspective of a grid that crosses multiple zones.
Also, while the buildings don't change that fast, I imagine usage varies wildly from pre-1970 patterns... And large commercial buildings (e.g. skyscrapers) older than 1970? How many of those really exist?
Posted Oct 10, 2021 18:12 UTC (Sun)
by Wol (subscriber, #4433)
[Link] (1 responses)
Why? Einstein said all time is relative, don't make one zone absolute. It was bad enough when Magellan went round the world and couldn't understand why everybody else was a day wrong in their calendar. What are the space station astronauts going to when they come home after 6 months and their UTC isn't the same as everyone else's?
MOST people don't have anything to do with timezones. MOST people have difficulty (including programmers) dealing with timezones.
As per Einstein time depends on the observer. And how many systems do you know, with historic time data, that have no concept of time zone? Most of them? The ONLY special time zone is the one you're in. And it's only special because YOU ARE THE OBSERVER.
Just define time as being 24 hours a day, clock time as the time from the preceding midnight OF INTEREST (so a night shift can quite happily end AFTER midnight eg 30:00 hours), and a full unambiguous spec is "local time T zulu offset" with NO guarantee that local time is less than 24:00 or that zulu offset lies between -12:00 and +12:00. The ONLY thing you guarantee is that if you normalise time, the day will move to correct time to the *expected* 24 hours. And on request time zone will normalise to zulu.
Cheers,
Posted Oct 20, 2021 14:07 UTC (Wed)
by 1kay (subscriber, #154880)
[Link]
Posted Sep 29, 2021 10:52 UTC (Wed)
by taladar (subscriber, #68407)
[Link]
Posted Sep 29, 2021 16:05 UTC (Wed)
by Homer512 (subscriber, #85295)
[Link] (6 responses)
Let's hope whoever built the database didn't follow best-practices and just keep all dates in local time without specifying time zones. Now the worst that could happen is that my retirement kicks in a day late or so.
Posted Oct 1, 2021 11:21 UTC (Fri)
by tonyfinn (guest, #144891)
[Link] (1 responses)
Or you get refused for important documents, background checks, or whatever because you provided the "wrong" date of birth?
Posted Oct 2, 2021 11:01 UTC (Sat)
by Homer512 (subscriber, #85295)
[Link]
Posted Oct 3, 2021 7:29 UTC (Sun)
by tedd (subscriber, #74183)
[Link] (3 responses)
Posted Oct 3, 2021 10:08 UTC (Sun)
by rsidd (subscriber, #2582)
[Link]
Posted Oct 3, 2021 12:23 UTC (Sun)
by mathstuf (subscriber, #69389)
[Link] (1 responses)
Posted Oct 4, 2021 13:39 UTC (Mon)
by Wol (subscriber, #4433)
[Link]
Cheers,
Posted Sep 29, 2021 16:07 UTC (Wed)
by ceplm (subscriber, #41334)
[Link]
I am sorry, but I don't think it is the key word. Whatever I think about astrology (and it is nothing good) is completely irrelevant to its share of use of tzdb. The only relevant metric is number of astrology programs (or number of their users) vis-a-vis other types of programs.
Posted Sep 30, 2021 23:49 UTC (Thu)
by azz (subscriber, #371)
[Link] (1 responses)
Posted Oct 1, 2021 17:11 UTC (Fri)
by JanC_ (guest, #34940)
[Link]
Posted Sep 29, 2021 5:44 UTC (Wed)
by flussence (guest, #85566)
[Link] (4 responses)
Imagine the chaos if Unicode's UCD was run this way and old codepoints got retconned to "tidy things up". +1 for forking this into the CLDR.
Posted Sep 30, 2021 11:41 UTC (Thu)
by foom (subscriber, #14868)
[Link]
Furthermore, it has never pretended to be an actuate record of pre-1970s fact. That had been documented all along (e.g. https://data.iana.org/time-zones/tzdb-2016g/Theory)
Posted Oct 1, 2021 11:23 UTC (Fri)
by tonyfinn (guest, #144891)
[Link] (2 responses)
Backticks are confusing because of dead keys and confusion with quotation marks, they only get into the valuable one byte characters because programmers designed the spec, better relocate them.
Posted Oct 2, 2021 1:48 UTC (Sat)
by tialaramex (subscriber, #21167)
[Link]
Posted Oct 10, 2021 0:01 UTC (Sun)
by flussence (guest, #85566)
[Link]
Posted Sep 29, 2021 7:04 UTC (Wed)
by eru (subscriber, #2753)
[Link] (106 responses)
An odd argument about Guandong and Shanghai. Aren't they both in in the country of China, so unifying should be uncontroversial?
Oslo and Berlin are in different countries, which in principle could at some point in the future decide to have different time zone rules. This is actually not just a theoretical possibility: There is a long-running debate in Europe about ditching DST. If that happens, different European countries may make different decisions about sticking to normal time or having a "permanent DST".
It seems to me counterproductive to unify rules of different countries.
Posted Sep 29, 2021 10:54 UTC (Wed)
by taladar (subscriber, #68407)
[Link]
Posted Sep 29, 2021 11:45 UTC (Wed)
by hkario (subscriber, #94864)
[Link] (29 responses)
Posted Sep 29, 2021 15:05 UTC (Wed)
by nim-nim (subscriber, #34454)
[Link]
Posted Sep 29, 2021 16:11 UTC (Wed)
by HenrikH (subscriber, #31152)
[Link] (25 responses)
Posted Sep 30, 2021 6:56 UTC (Thu)
by cpitrat (subscriber, #116459)
[Link] (24 responses)
Posted Sep 30, 2021 7:28 UTC (Thu)
by amacater (subscriber, #790)
[Link] (23 responses)
The timezones being updated - it happens about once a month, I think. Brazil seems to change definitions fairly regularly, from memory, for example. That's inconvenient: losing historical data would be criminal. The one thing I'd dearly love would be for US folks to stop using descriptive names for timezones and start using UTC+/- to denote times more often. With one colleague West Coast USA, one colleague East Coast, one on Indian Standard Time, one in Paris and two in UK for a six person team, I _always_ have to look up what time it is in two places to get an idea of who will be in the meeting for our Thursday meeting at 1900 UTC.
Posted Sep 30, 2021 10:19 UTC (Thu)
by LtWorf (subscriber, #124958)
[Link] (22 responses)
Posted Sep 30, 2021 16:43 UTC (Thu)
by marcH (subscriber, #57642)
[Link] (21 responses)
I used to think it was a privilege. Then I got reports of bugs that happened everywhere except in GMT. From that moment I permanently set some test systems in a non-zero timezone.
Another useful test trick I just discovered: there is a +14:00 and a -11:00 timezone, which means they are _never_ on the same date. Perfect to trigger some bugs with a simple and local TZ environment change.
Probably the most funny timezone experience was with code entering timestamps into MySQL. With daylight savings the same hour repeats in Autumn, that produced some very interesting graphs! After 10 years MySQL finally made it easy to enter a zone with the timestamp, before that the only workaround was switch the MySQL server to UTC.
Posted Sep 30, 2021 17:08 UTC (Thu)
by amacater (subscriber, #790)
[Link] (20 responses)
This is how the military keep time. [Flying as a civilian with the RAF - "Do you want UK time, Hong Kong time, local time on the ground or RAF time?"] - the pilots keep one timezone wherever they fly in the world and eat/sleep etc. accordingly. The only oddity, done for log keeping purposes is that 2359 leads seamlessly to 0001 so that there is never an ambiguity as to date. Seasoned Services folk claim that the odd few seconds are "your time" in the day.
Posted Sep 30, 2021 17:25 UTC (Thu)
by Wol (subscriber, #4433)
[Link]
Cheers,
Posted Sep 30, 2021 23:29 UTC (Thu)
by marcH (subscriber, #57642)
[Link] (18 responses)
This sequence is also very funny: 10am, 11am, 12pm(!), 1pm, 2pm
But what _really_ cracks me up is when people read "military time" aloud. Example:
16:21 = sixteen HUNDREDS (!!) twenty one
Remember this is in the country where nothing is DECIMAL but a happy mix of units in base 4, base 12 and what not instead. So the only unit where base 10 sort of made it is actually https://en.wikipedia.org/wiki/Sexagesimal! Hilarious.
Posted Oct 1, 2021 9:27 UTC (Fri)
by excors (subscriber, #95769)
[Link] (17 responses)
Seems quite logical to me, since time is a continuous value:
11:59:59.999 - before midday, so definitely "am" (ante meridiem)
The (sensible) convention is for midday precisely to be called "pm", which means the label changes at the same point that the numbers roll over, and you avoid having an infinitesimal period where it's 12 but still "am". Then you can easily truncate any "hh:mm:ss.sss" down to "hh:mm:ss" or "hh:mm" or "hh" without having to worry about crossing the threshold where the label changes.
On the other hand, I'll agree that 12 o'clock really should be 0 o'clock.
Posted Oct 2, 2021 5:43 UTC (Sat)
by jezuch (subscriber, #52988)
[Link]
Posted Oct 2, 2021 18:02 UTC (Sat)
by intelfx (subscriber, #130118)
[Link] (15 responses)
- "10am" = 10+0 = 10
Like most other things, it's a matter of perspective. I trip over this notation constantly.
Posted Oct 2, 2021 19:53 UTC (Sat)
by NYKevin (subscriber, #129325)
[Link] (14 responses)
* 0:xx = 12:xx AM (just memorize)
These mnemonics work largely because 12 is a highly composite number, and adding 12 to any given number doesn't change its divisibility by any factor of 12 (i.e. if x is divisible by some factor of 12, then so is x + 12). The primes, on the other hand, appear to arise for the opposite reason, which is that 12 covers nearly all of the available prime factors (i.e. if x is *not* divisible by some factor of 12, then neither is x + 12), and the few that it misses are just not dense enough to stop the shifted primes from existing.
Posted Oct 2, 2021 21:23 UTC (Sat)
by rschroev (subscriber, #4164)
[Link] (13 responses)
* 0:xx = 12:xx AM (just memorize)
I don't think I understand why you would need to memorize anything (apart from the possible confusion with 12 AM/PM).
Posted Oct 3, 2021 0:11 UTC (Sun)
by Wol (subscriber, #4433)
[Link] (7 responses)
You have the same problem with the 24-hr clock - is midnight 0:00 or 24:00? But it's the exact same rule - the day STARTS at midnight 0:00 exactly.
(Then, of course, you have all those weirdos where time-keeping applications apply the rule that a work shift always ends the same day it starts, so it would have had my hours as working from 22:00 to 32:00 ...)
Cheers,
Posted Oct 3, 2021 7:38 UTC (Sun)
by marcH (subscriber, #57642)
[Link] (6 responses)
Posted Oct 3, 2021 8:23 UTC (Sun)
by Jonno (subscriber, #49613)
[Link] (5 responses)
Actually there is a 24:00:00.000, but not 24:anything-else. This is so you can describe the end of a day without involving the next date. For example 2011-02-28T24:00:00.000 equals 2011-03-01T00:00:00.000 exactly.
This is especially convenient for time durations ending at midnight. For example you can say "Open at 2011-02-28 from 16:00 to 24:00" instead of "Open from 2011-02-28 16:00 to 2011-03-01 00:00".
Posted Oct 3, 2021 16:13 UTC (Sun)
by marcH (subscriber, #57642)
[Link] (4 responses)
Understood but I don't remember seeing that anywhere I've been.
> Actually there is a 24:00:00.000, but not 24:anything-else. This is so you can describe the end of a day without involving the next date.
So how does that help "from 16:00 to 00:30"?
Posted Oct 3, 2021 17:15 UTC (Sun)
by Jonno (subscriber, #49613)
[Link] (3 responses)
It doesn't. But in that case you are actually open during two different calendar days, so it is natural that you need two different dates to unambiguously describe the period of time in question. But if you close at midnight, you are only open during one calendar day, so the need to use two different dates for the opening and closing time would be awkward, thus the 24:00 special case.
( BTW, the same is true of some am/pm usages, where "12:00 am" is equivalent to "00:00", "12:00 noon" is equivalent to "12:00" and "12:00 pm" is equivalent to "24:00". Of course, in other am/pm usages "12:00 am" ambiguously refer to midnight at either the start or the end of the day, while "12:00 pm" refer to noon; and in yet other am/pm usages "12:00 am" refer to "noon", while "12:00 pm" ambiguously refer to midnight at either the start or the end of the day. Neither of these usages makes sense if you consider the literal meaning of am (ante meridiem - before noon) and pm (post meridiem - after noon): at noon it is neither before noon nor after noon, so both am and pm are incorrect, while at midnight it is equally after one noon and before another noon, so either am or pm can be equally correct, depending on which noon you are referring to. Even so, both the later two versions are more common than the first. Most computer systems consider "12:00 pm" to be noon, but before the age of computers using "12:00 am" for noon was clearly the most common usage... )
>> For example you can say "Open at 2011-02-28 from 16:00 to 24:00"
It's fairly uncommon for places to close at midnight, as most "normal" businesses close earlier and most "nightlife" establishments close later, but in the rare cases someone actually closes at midnight, I have only ever seen opening hours listed as "16:00 - 24:00", never as "16:00 - 00:00".
Posted Oct 3, 2021 18:29 UTC (Sun)
by Wol (subscriber, #4433)
[Link]
Clearly unambiguous for anything that is expecting it ... :-) and gets round the problem of special-casing shifts that finish before they start ... at the cost of having to handle shifts that end after the normal end of the day.
Cheers,
Posted Oct 3, 2021 19:52 UTC (Sun)
by perennialmind (guest, #45817)
[Link] (1 responses)
The best I can say in defense of the clock's modulo-12 residue starting system at 1 is that it's not technically wrong, merely suboptimal.
Posted Oct 3, 2021 20:10 UTC (Sun)
by marcH (subscriber, #57642)
[Link]
There would be no am/pm inconsistency if 12h clocks counted from 0:
0:00am 1:00am ... 11:00am 0:00pm 1:00pm ... 11:00pm
When the zero was invented, tens and hundreds and thousands started from 0 but units kept starting at 1 for obvious "backward compatibility" reasons. This is the root cause of many inconsistencies and why 24h clocks and most programming languages switched to counting from zero.
Posted Oct 3, 2021 4:34 UTC (Sun)
by NYKevin (subscriber, #129325)
[Link] (4 responses)
Posted Oct 3, 2021 7:46 UTC (Sun)
by marcH (subscriber, #57642)
[Link] (1 responses)
Posted Oct 4, 2021 22:10 UTC (Mon)
by Wol (subscriber, #4433)
[Link]
Cheers,
Posted Oct 3, 2021 11:34 UTC (Sun)
by rschroev (subscriber, #4164)
[Link] (1 responses)
Posted Oct 3, 2021 12:16 UTC (Sun)
by mathstuf (subscriber, #69389)
[Link]
Posted Oct 1, 2021 11:24 UTC (Fri)
by tonyfinn (guest, #144891)
[Link] (1 responses)
Posted Oct 1, 2021 14:10 UTC (Fri)
by farnz (subscriber, #17727)
[Link]
And, of course, showing just how much politics is involved, there is always the wild card of Irish Reunification - the possibility that NI will diverge by enough from GB that it leaves the UK and the island of Ireland becomes one country. Or if something truly weird and currently unlikely happens, and the island reunifies because Ireland joins the UK instead of remaining a republic.
Irish reunification as a political event is unlikely to be timed conveniently for timezone shifts; we could well have something where the "Europe/Dublin" timezone follows GB until reunification and then changes to UTC+0 or UTC+1 all year round.
Timezones are inherently a political matter, and they (unfortunately) don't respect the desires of computer people.
Posted Sep 29, 2021 12:27 UTC (Wed)
by smoogen (subscriber, #97)
[Link] (71 responses)
In the end, names for a major city in a zone always cause headaches because of this. There are enough people who hate whatever city is chosen that they will make it a campaign to make sure it isn't mentioned.
Posted Sep 29, 2021 15:43 UTC (Wed)
by nim-nim (subscriber, #34454)
[Link] (41 responses)
(hint : the departments were specifically created during the French revolution to break up historical regions because those regions tended to oppose whoever was in power in Paris; an old project of the monarchy that suited the revolutionaries fine)
OTOH people are still warring in Ukraine along the border of the 1054 schism; Israelis recreated a political entity thousands of years after it was wiped out; WWI was in great part about Lorraine/Lothringen ie one of the last jolts of an 843 dispute between Charlemagne inheritors (with Lothair I the main loser).
Localization is a matter for local people and imposing your (mis)understandings on a region you have little knowledge of is a bad bad idea.
Posted Sep 29, 2021 16:26 UTC (Wed)
by smoogen (subscriber, #97)
[Link] (1 responses)
In the end, I am in complete agreement: Localization is for local people and can be quite quite local.
Posted Sep 29, 2021 16:49 UTC (Wed)
by nim-nim (subscriber, #34454)
[Link]
Which means the only “good” localization in France is France (or continental France vs non continental France because everyone realizes the French parts in America or the Pacific need special treatment in many cases).
France won’t make Corsicans or Bretons or Catalans very happy but they will hate identification with Parisians more.
Localization is as messy as human history.
Posted Sep 29, 2021 17:11 UTC (Wed)
by mbunkus (subscriber, #87248)
[Link] (38 responses)
Posted Sep 30, 2021 7:25 UTC (Thu)
by marcH (subscriber, #57642)
[Link] (37 responses)
US states matter because on many topics (majiruana, abortion, death penalty, guns,...) there is at least as much difference between two given US states than between two European countries. People in Europe like to laugh at geographical ignorance in the US but conversely...
For instance majiruana has basically the same status as alcohol in many US states now yet it is still in the most dangerous DEA category. See https://www.dea.gov/drug-information/drug-scheduling a.k.a. the "war" on drugs = the one immediately before the "war" on terror. The former was apparently much more successful that the latter because 0.7% of the US population (and mostly black) is still incarcerated. Some people have real "equity" problems. I digress sorry.
> similar to how requiring you to enter exactly one first & one last name is a Westernism.
You meant "given name" and "family name" of course :-)
Posted Sep 30, 2021 21:44 UTC (Thu)
by NYKevin (subscriber, #129325)
[Link] (3 responses)
(Or at least, that's what the founders *wanted.* What actually happened was, as soon as the ink had dried on the Fourteenth Amendment, Congress promptly decided to start inserting the phrase "in or affecting interstate or foreign commerce" into every law they wanted to pass that wasn't on the list, and the courts just went with it, so now the feds can do whatever they want under the legal fiction that they are "regulating commerce." But the states still retain considerable autonomy and the feds cannot simply tell them what to do, hence the discrepancies on marijuana policy and various other political issues.)
Posted Oct 1, 2021 13:58 UTC (Fri)
by mathstuf (subscriber, #69389)
[Link] (2 responses)
Posted Oct 1, 2021 16:24 UTC (Fri)
by nybble41 (subscriber, #55106)
[Link] (1 responses)
Really such rules ought to be deemed unconstitutional in any case. If Congress can't pass a law e.g. setting the drinking age to 21 under their own authority then they shouldn't be able to require states to do so on their behalf as a condition for receiving federal highway funding or any other benefit. Doing so implies that the state governments are acting as agents of Congress in passing those laws, which ought to be deemed equivalent to Congress passing the laws itself.
Posted Oct 1, 2021 19:24 UTC (Fri)
by marcH (subscriber, #57642)
[Link]
What a show. From an actor of course. Now it could have been worse, he could have been a TV reality star. Oh, wait...
Posted Oct 8, 2021 14:58 UTC (Fri)
by j16sdiz (guest, #57302)
[Link] (32 responses)
Not everybody have a family name.
Posted Oct 8, 2021 17:34 UTC (Fri)
by Wol (subscriber, #4433)
[Link] (1 responses)
Cheers,
Posted Oct 8, 2021 18:54 UTC (Fri)
by amacater (subscriber, #790)
[Link]
Folks can have an alias identity for whatever reason: Vagrant Cascadian is an alias, I believe.
Whatever you think a name is, you're likely wrong in some respect. Naming hosts is hard - https://xkcd.com/910/ - refers
Posted Oct 8, 2021 19:46 UTC (Fri)
by marcH (subscriber, #57642)
[Link] (29 responses)
Do you think "first" and "last" are better ?
I was merely suggesting a very quick fix for the Western world system, not something universal.
Posted Oct 9, 2021 11:00 UTC (Sat)
by mbunkus (subscriber, #87248)
[Link] (28 responses)
Using "given name" & "family name" is not a solution. It just slaps on a different coat of paint on the problem without solving it.
Names are complex. Even in the countries we call Western.
Posted Oct 10, 2021 18:54 UTC (Sun)
by marcH (subscriber, #57642)
[Link] (21 responses)
Agreed, but in the Western cultures the family/given split is good enough for the immense majority of people and has endured the test of time and is here to stay.
There have been big changes to family structure and even language recently in the Western world (much more change than in the rest of the world) yet there has been no loud request (yet?) to reconsider this name split. Not even on social media where everyone now loves sharing and spreading the craziest ideas whether they love them or hate them; only the emotions matter.
Even for "foreigners" the main issue is not this split but rather transliteration; a problem much older than computers. I guess that's because families have many different forms but the idea is pretty universal.
> Using "given name" & "family name" is not a solution. It just slaps on a different coat of paint on the problem without solving it.
No, it gives the current, unique and good enough solution its accurate... name. Naming things for what they actually are is really not just "slapping a different coat" and in this case it has proved useful for people from various origins who can get very easily and obviously confused by "first" and "last".
Posted Oct 10, 2021 19:11 UTC (Sun)
by zdzichu (subscriber, #17118)
[Link] (20 responses)
Posted Oct 11, 2021 7:42 UTC (Mon)
by Wol (subscriber, #4433)
[Link] (3 responses)
EVEN IN THE WEST we have two very different naming systems.
We have Christian name(s), patronymic, (surname)
So you can see the drift ... Patronymical cultures don't normally use surname. MANY people don't use First name (the Germans certainly used to use a way of handling this - I've seen Ausweis/Reisepass with the second name underlined, to indicate this is the "name that is used".
I'm guessing that Anglo-Saxon names like Smith and Miller are surnames - typically a *professional* name handed down the generations, while Johnson, Smithson, MacGregor, McIntyre, are patronymics, eg James son of John, Gregor son of Gregor.
When the surname habit froze in I don't know, but I'm guessing it was fairly recent ...
Cheers,
Posted Oct 11, 2021 9:15 UTC (Mon)
by farnz (subscriber, #17727)
[Link] (2 responses)
Even in England, we have two systems in parallel; there's the "Christian name, surname" one that most people think of, but there's a significant minority (who have money) that have "inherited name, personal name, surname", where they are only "inherited name, surname" in very formal situations, but they're "personal name" or "personal name, surname" otherwise.
So I have an acquaintance (let's call him "John"), whose name on his passport is something like "James John Smith", but whose bank cards etc are in the name of "Mr John Smith". The only time he uses "James" (which is the name the eldest son was given in each generation, and has the family lands attached to it) is when he's dealing with courts, police, or equivalents.
And this ignores such fun as stage names - e.g. without looking it up, I'd not recognise "Newton Edward" as the first names of someone whose ID normally calls him "Paul Daniels", and yet I know exactly who Paul Daniels is because he was a common fixture on BBC TV 30 to 40 years ago.
Posted Oct 11, 2021 10:15 UTC (Mon)
by Wol (subscriber, #4433)
[Link]
And the reason a lot of people do not use the real name on stage is because acting is a closed shop, you MUST have an Equity card, and no two people can have the same name on active Equity cards.
The reason we know him as David W*A*lliams is because somebody else already had a card in the name of David W*I*lliams.
So yes. It's a very safe bet that most people on stage don't go by their real name because they couldn't get a card with that name on it ...
Cheers,
Posted Oct 11, 2021 11:36 UTC (Mon)
by Wol (subscriber, #4433)
[Link]
:-) To give a real life example, I believe a certain personage uses the name "Charlie Chester" (ONE of his real names!) when he wants to fly under the radar a bit ...
His son was known for a while as Cornet Wales ...
Cheers,
Posted Oct 11, 2021 8:28 UTC (Mon)
by marcH (subscriber, #57642)
[Link] (15 responses)
Pure slideware / bullet points with zero reference, examples, number or any sort of evidence. Zero recommendation or anything anywhere close to a solution.
My favorite falsehood is the last one: "some people don't have a name". Fine, keep not using a computer then and all problems solved!
Posted Oct 11, 2021 11:44 UTC (Mon)
by Wol (subscriber, #4433)
[Link]
And why should it set out to provide a solution? It's setting out to provide a map of the bear-traps. It's not setting out to provide a map of your best route around them!
It's down to YOU to find the correct solution for YOUR circumstances. How often do I curse blue bloody murder - AND USUALLY WALK AWY - at websites that - because their designers DIDN'T THINK - won't let me enter correct data. How many websites demand a mobile phone number, when a lot of their customers won't have one? All because they insist on texting you delivery information, for example.
Unfortuntely your typical programmer analyst is doing a job and doesn't bother to think. The analyst is unaware of the real problem-space, and the programmer does what he's told. And the poor sod at the sharp end curses because the problem the computer solves isn't the one he's got!!!
Cheers,
Posted Oct 11, 2021 13:36 UTC (Mon)
by farnz (subscriber, #17727)
[Link] (13 responses)
A lot of it comes down to "in this situation, how should the system refer to you?". For example, a chat system might want a display name for other humans to use; a tax system might want an identity the government uses for you. LWN wants nicknames for comments, Facebook wants an "authentic" name.
If you're going to design for a "name", you need to know what you want it for in order to ask the human for the right thing.
Posted Oct 11, 2021 14:37 UTC (Mon)
by smurf (subscriber, #17840)
[Link] (12 responses)
I truly don't get why y'all are going to such lengths. Offer a "how do you want to be addressed" field, a "which country / administration do you live in" (that wording should cover Taiwan, Palestine, or Transnistria) menu, and a "what should be on the address label of a package to you" multi-line field. All of which gotta be Unicode capable and not filter out random characters (no, Bobby Tables must not be prevented from causing havoc by filtering user input, thank you very much).
Then you can lean back in comfort and watch everybody else struggle with this nonsense.
Posted Oct 11, 2021 16:45 UTC (Mon)
by mpr22 (subscriber, #60784)
[Link]
aaaaa
don't talk to me about address formats
I deal with a pair of systems (and their constellation of client websites) that separate "house number or name" from "street", require both fields to be populated, and always present them HNON first
which is a piece of gibbering anglocentric stupidity (and doesn't even work everywhere in england)
but I'm not allowed to set it on fire
Posted Oct 11, 2021 23:09 UTC (Mon)
by sammythesnake (guest, #17693)
[Link] (10 responses)
I deliver for Amazon and every day I have to deliver to addresses that are missing the house number, or the street name, or it's there but spelled incorrectly, or doesn't exist, or have a postcode in a different city from the rest of the address...
All addresses should be either from the database in a canonical form, or behind a scary warning that if you change your address from that canonical form, your package may-or-may-not ever arrive.
Of course, once I get there, I'll still have to handle houses without the number/name anywhere to be seen with numbering orders that must be the product of a stroke* and so on, but let's at least let's solve this one problem that we so easily could, eh?
* Example from today. 10, 9, 3, 4, 7, 8, 5, 6. No house 1 or 2. I swear they get together to drink absinthe and dream up new ways to make no sense...
Posted Oct 12, 2021 0:22 UTC (Tue)
by mpr22 (subscriber, #60784)
[Link]
https://en.wikipedia.org/wiki/Address
The only internationally portable way to represent addresses, if you don't have the budget to throw piles of money at a company whose primary revenue stream is extracting capitalist rent from control of access to an address database, is as a series of freeform lines written in either Latin letters or the addressee's native script.
It should be noted that even the craziest house numberings usually have some kind of logic, though you may have to analyse its development diachronically rather than synchronically for it to become apparent.
Posted Oct 12, 2021 9:13 UTC (Tue)
by farnz (subscriber, #17727)
[Link] (3 responses)
Context is everything. If you're getting an address to hand over to a delivery agent, the address should come from a mapping database shared with the agent, so that what you get when you have an Amazon parcel to drop off is in a form usable to you - and that can mean that the address you have for me is a shipping point, not my home (e.g. a PO Box). If you're getting an address to share with the government for tax reasons, it should be in a form that the government is happy with.
And as the delivery company, or the government, you keep a database (either in-house, or bought in from a mapping provider) that contains all the addresses you want in a form that you're happy with. That way, you get a decent location for your parcel deliveries; downside is that your company has to maintain that database so that everyone's address is in it.
Free form addresses are fine if you're gathering something that the user will want to simply share with friends.
Posted Oct 12, 2021 11:51 UTC (Tue)
by nye (subscriber, #51576)
[Link] (2 responses)
That doesn't work in practice though, because the delivery is not done by some nebulous "company", but by a delivery person who has to drive a van around looking for the address on the package. The company hasn't individually looked over each address and checked that it's in the most accessible form; that would be impossible. A person knows their address; "normalising" it to something that conforms to a database created by a machine doesn't magically improve things by virtue of having it in some "consistent" format, because real addresses fundamentally aren't consistent.
My address technically looks like this:
Unfortunately "Some Street" isn't accessible by car so isn't on every satnav database, which frequently can't understand that concept. The street that it branches off is on all of those databases though, so after living here a while, we worked out that delivery drivers had a much higher success rate if we render our address as:
Systems which try to normalise this end up making the result categorically worse for us and for the people trying to deliver to us.
(Shout out to Kickstarter which requires me to double-confirm my address for every project I back, including having to pick a radio box to say that yes I really do want to use the address you made me re-enter again, and not your oddly mangled version that you describe as "more precise" but has two of the lines merged for no reason. Fuck you.)
Posted Oct 12, 2021 12:22 UTC (Tue)
by farnz (subscriber, #17727)
[Link] (1 responses)
Which is a failure of the database that's on offer - and really should be in delivery notes, not part of the address. So your address as stored in Amazon's systems should be "1 Some Street, Town, County, Postcode", with a note for the driver saying "Some Street is not accessible by car - go to 2 The Other Street, and then you can walk it".
The delivery notes, of course, are free-form.
Ideally, there would be routes to feed back the issue to the database owner, so that when you pick "1 Some Street" for your Amazon package, the resulting label and bar codes direct their in-van satnav to "2 The Other Street" and tell them to walk the rest of the way.
And Kickstarter have no excuse - when you first add your address to your account, they can ask you if you made a mistake, but after that they should be using the address on file as-is, not insisting on reconfirmation. While they may well be right that you're getting the address "wrong" (if it's a UK address, the correct form loses County nowadays, so it would be "1 Some Street, Town, Postcode"), they should only be asking you to correct it if it's actually causing problems.
Posted Oct 12, 2021 18:52 UTC (Tue)
by Wol (subscriber, #4433)
[Link]
Cheers,
Posted Oct 12, 2021 13:16 UTC (Tue)
by jezuch (subscriber, #52988)
[Link] (2 responses)
Posted Oct 12, 2021 14:01 UTC (Tue)
by excors (subscriber, #95769)
[Link]
Posted Oct 12, 2021 14:19 UTC (Tue)
by smurf (subscriber, #17840)
[Link]
Google's plus code isn't that much better.
The only location-encoding system that makes some kind of practical sense IMHO is Uber's H3. It just needs a reasonably pronounceable overlay.
Posted Oct 12, 2021 17:56 UTC (Tue)
by Wol (subscriber, #4433)
[Link]
Trouble is, the database isn't in a canonical form ... and all too often they assume that all you NEED is the postcode and the house number. So it's quite normal to have number, street, and the post town 20 miles away ... together with the post code that does uniquely identify the property you want - but it would be nice if the address actually included the town/village where said property was located ...
(Speaking as another guy who has spent the last god knows how many years driving a delivery van ...)
Cheers,
Posted Oct 23, 2021 14:38 UTC (Sat)
by nix (subscriber, #2304)
[Link]
Posted Oct 10, 2021 19:36 UTC (Sun)
by divanise (subscriber, #71550)
[Link] (5 responses)
Mostly agree, but storing two fields ("full name", eg "Johnathon Hancock", and "goes by", eg "Johnny") is a significant improvement for roughly equivalent effort over the naive "first name/last name" approach. I've advocated for "full/goes by" ever since I first came across it, but often fail due to either legal obligations or API restrictions that require collecting "first name/middle initial/last name".
Posted Oct 10, 2021 19:52 UTC (Sun)
by mbunkus (subscriber, #87248)
[Link] (1 responses)
I fear such two fields would be even more confusing to users than the typical but widely used "given & family name" or similar, meaning the entity storing the data couldn't realistically make good use of it.
Of course there are instances where you need specific pieces of information, e.g. if you need a person's name as given on their passport (for official things such as crossing borders). And maybe it's useful to have an additional fields for more informal communication between that entity and you. But if that's the case (and I'd guess that such cases are really rare), be explicit in what you name those fields, really explicit, so that there's no doubt what they'll be used for. For example: "Name as written on your passport" and "Preferred name for us to use when communicating with you".
Posted Oct 11, 2021 15:04 UTC (Mon)
by smurf (subscriber, #17840)
[Link]
As one datapoint, nowadays I need to provide all three of my "first" names on banking-related douments because of the current crop of gobsmackingly dumb regulations. But nobody should ever use anything but the second of those names to address me. No, not the first, and certainly not all three, I'm not the male equivalent of Pippi Longstockings dammit.
Now this is certainly a First World Problem compared to people who are named O'Hare and cannot even enter that due to broken Bobby Tables Prevention filters, much less my acquaintance Aahz (yes that's his single real-life name), or … the list goes on.
Posted Oct 10, 2021 20:07 UTC (Sun)
by mpr22 (subscriber, #60784)
[Link] (1 responses)
If I were more conservative about correspondence etiquette, I would expect it to open with "Dear Mr (Surname)"... but if I were that conservative about correspondence etiqutte and had a knighthood that they knew about, I would expect them to address me as "Sir (Forename)". And I would expect all of that without having to "jump through hoops" on their website, expecting simply putting my title, forename, and surname to be sufficient.
And as I am, I get mildly grumpy about letters opening "Dear (Forename) (Surname)" because they fall between two stools, satisfying neither my own casualism nor the standards expected by the formalist in my head.
Posted Oct 23, 2021 15:23 UTC (Sat)
by nix (subscriber, #2304)
[Link]
Given the perennial state of UK government software I'm sure this is all a thousand times better by now! (Oh wait, that was a typo. I meant "worse".)
Posted Oct 11, 2021 9:25 UTC (Mon)
by farnz (subscriber, #17727)
[Link]
Ultimately, the "right" thing to do is to have a "name for this purpose" field, provide some pre-fill features that helps someone with an expected naming convention fill in what you expect. Bear in mind that "full name" is itself ambiguous - is the full name "Paul Daniels" (which was the only name on much of his ID), or "Newton Edward Daniels" (as per his birth certificate, and marked as an additional full name on his passport)? You may even need multiple full names for one person…
Posted Sep 29, 2021 16:26 UTC (Wed)
by dmoulding (subscriber, #95171)
[Link] (8 responses)
I'd much prefer if I could select, you know, the actual timezone I live in instead of the (not even nearest) large city that happens to be in the database. US/Mountain would make a lot more sense than America/Denver. What if Colorado decides to stop doing DST next year? Or what if Utah does? *grumble, grumble*
Posted Sep 29, 2021 17:49 UTC (Wed)
by tialaramex (subscriber, #21167)
[Link] (1 responses)
For example, suppose the government decides that it'd love to invent a new "Plains" zone that's half an hour off Mountain, except on a Tuesday or if Congress is in session, and then it's twice as much, or it isn't at all, either way. They can write that down, and that's your "Plains" zone. But, of course, this is utter nonsense and nobody will obey it.
If the local politicians dictate that now Salt Lake City shall follow Plains time, immediately they find they are obliged to actually make this work. Salt Lake City is hardly a sprawling metropolis, but it's big enough that it can't very well cope with this vague nonsense like "twice as much, or it isn't at all" and they must come to some sort of practical arrangement e.g. you know what, we'll skip this whole Tuesdays and Congress thing and just always be offset by +30 minutes. You may see similar with the need for lunar calendars, when somebody's multi-billion dollar business is on the line sure enough "Every night the village elder looks at the moon to decide if it's a new month" isn't good enough like it used to be and a model is used to deliver certainty instead. Having figured out how to actually make it work, it's now suitable for tzdb and (not coincidentally) also now useful to put in tzdb.
So, that's why America/Denver (a city, on a continent, which I expect will be there for centuries and maybe longer) rather than US/Mountain (wouldn't bet too much on either the US or Mountain time existing in a hundred years).
If you'd like to experience the other side of the coin, just use more Microsoft stuff. Some of their newer stuff uses the tzdb, but older stuff is wedded to Microsoft's implementation of exactly what you wanted. Presumably, them being Americans, it works out OK for the US. But for example, I have to pick GMT. It isn't GMT here, but that's what I have to pick, because that's the "zone".
Posted Sep 29, 2021 19:30 UTC (Wed)
by mfuzzey (subscriber, #57966)
[Link]
So in your example that's great for those living in Denver but what about the next town?
How to group an infinite number of geographical points like cities, towns, villages into a finite number of time zones is still a political decision even if the zones are named after cities.
Posted Sep 29, 2021 18:15 UTC (Wed)
by rsidd (subscriber, #2582)
[Link] (1 responses)
Kolkata is an odd choice since it was a relatively late entrant to IST (1948; IST was established in 1906). But hey, who cares.
Posted Sep 29, 2021 20:12 UTC (Wed)
by magfr (subscriber, #16052)
[Link]
That almost did work but sadly Jerusalem got picked by the rule and now the Palestinian rule also wants Jerusalem.
Jerusalem should probably be on some kind of avoidance list as that city seems to trigger people.
Posted Sep 30, 2021 5:25 UTC (Thu)
by interalia (subscriber, #26615)
[Link] (2 responses)
I guess the human-interface and the tzdb problems are technically independent, in that tzdb could ship with no zone names and just have a whole bunch of zones given SHA codes, with parent SHAs to cover historical changes - a bit like git branches. The human timezone names could just be tag-like references to these SHA codes, but whoever maintains this list of tags will face a similar problem of what names to include and what to exclude. And people would probably want it shared for consistency across apps and OSes, you wouldn't really want each library/language or OS to re-implement it differently.
Posted Oct 23, 2021 15:27 UTC (Sat)
by nix (subscriber, #2304)
[Link] (1 responses)
Posted Oct 23, 2021 16:54 UTC (Sat)
by mpr22 (subscriber, #60784)
[Link]
(At least, I'm assuming there might be somewhere in the southern hemisphere that has DST.)
Posted Oct 1, 2021 17:20 UTC (Fri)
by chfisher (subscriber, #106449)
[Link]
Posted Sep 29, 2021 22:52 UTC (Wed)
by mattdm (subscriber, #18)
[Link] (10 responses)
On a more serious note, I was myself confused by this naming convention at the beginning of this week, updating my timezone temporarily to US West Coast. I'm in Seattle. Turns out that's... Los Angeles, a thousand miles away. Okay.
Posted Sep 30, 2021 1:59 UTC (Thu)
by sfeam (subscriber, #2841)
[Link] (9 responses)
I use "America/Vancouver". It's a lot closer.
Posted Sep 30, 2021 2:48 UTC (Thu)
by mattdm (subscriber, #18)
[Link] (8 responses)
But really, in seriousness: when you travel somewhere, how are you supposed to know what most populous city happens to follow the same timezone rules as that place? It shouldn't be a trivia contest.
Posted Sep 30, 2021 2:56 UTC (Thu)
by corbet (editor, #1)
[Link]
I long since gave up on putting the laptop on local time. It's always US/Mountain ("Denver" - annoying to us Boulder folks) in laptopland. The phone (almost) always figures things out on its own, so that's where I look for the time.
Posted Sep 30, 2021 8:28 UTC (Thu)
by NYKevin (subscriber, #129325)
[Link] (1 responses)
Posted Sep 30, 2021 10:22 UTC (Thu)
by SiB (subscriber, #4048)
[Link]
Posted Oct 10, 2021 16:49 UTC (Sun)
by ssmith32 (subscriber, #72404)
[Link] (4 responses)
Posted Oct 10, 2021 16:59 UTC (Sun)
by amacater (subscriber, #790)
[Link] (3 responses)
Posted Oct 11, 2021 9:07 UTC (Mon)
by farnz (subscriber, #17727)
[Link]
The best interface is almost certainly based on geolocation (privacy risk!). Basically just identify where you are, and offer a list sorted by probability that it's your timezone based on your location. This is not a simple solution, mind.
Posted Oct 11, 2021 14:42 UTC (Mon)
by smurf (subscriber, #17840)
[Link] (1 responses)
Both lists and maps have serious shortcomings, but not to the same set of people. Thus you offer both, done.
Posted Oct 11, 2021 17:01 UTC (Mon)
by excors (subscriber, #95769)
[Link]
It's still a problem if you omit the country names but show the borders: https://devblogs.microsoft.com/oldnewthing/20030822-00/?p...
> In early 1995, a border war broke out between Peru and Ecuador and the Peruvian government complained to Microsoft that the border was incorrectly placed. Of course, if we complied and moved the border northward, we’d get an equally angry letter from the Ecuadorian government demanding that we move it back. So we removed the feature altogether.
(And if you don't even show borders then it'll probably be very hard for most people to locate themselves on the map.)
Posted Sep 30, 2021 11:02 UTC (Thu)
by jschrod (subscriber, #1646)
[Link] (8 responses)
I'm from Germany. Every lay person here thinks that they live in the time zone CET / CEST. (Actually, MEZ / MESZ in German.) No non-computer-professional would recognize Europe/Berlin as a timezone designation in the first place.
I always thought that the Europe/* tz names were introduced as help for program or OS installations, where one can pick one's country. I.e., where the capital is used as a human representation of an ISO-country code. In fact, I always wondered why it's called Europe/Berlin and not Europe/Germany or even Europe/DEU.
Well, since some people here seem to be hellbound to remove DST anyhow, and different for each European country, this tzdb change won't live long anyhow.
Posted Oct 3, 2021 18:32 UTC (Sun)
by marcH (subscriber, #57642)
[Link] (7 responses)
I guess Timezones are labelled after cities because no politician has yet been crazy enough to separate a single city into multiple timezone.
Posted Oct 4, 2021 5:26 UTC (Mon)
by alonz (subscriber, #815)
[Link] (1 responses)
Posted Oct 4, 2021 16:53 UTC (Mon)
by marcH (subscriber, #57642)
[Link]
Once the afterlife gets involved, the possibilities become totally unlimited...
Posted Oct 7, 2021 6:44 UTC (Thu)
by branden (guest, #7029)
[Link] (4 responses)
"I guess Timezones are labelled after cities because no politician has yet been crazy enough to separate a single city into multiple timezone."
Nicosia called and wants its 1973 unified timezone back.
Posted Oct 9, 2021 9:43 UTC (Sat)
by marcH (subscriber, #57642)
[Link] (3 responses)
Anyway in such cases new names show up:"Northern Nicosia", "West Berlin" and problem solved.
Posted Oct 9, 2021 10:21 UTC (Sat)
by Wol (subscriber, #4433)
[Link] (2 responses)
Even Britain/London is a mess. Which London? And, just like New York City is not the capital of New York State, the capital of Britain is not the City of London, it's the City of Westminster about two miles away.
Borders might not move, but towns and cities do - another favourite example of mine is Dover, where the town centre is in the village of Charlton, about two miles from away from Dover itself (which historically is just Snargate Street, by Western Docks, for those who know the place).
I'm sure pretty much any historic country (which excludes the US, which is why they don't understand these things) will have plenty of examples. All it takes is a river, and then some invading army makes the river the border, and then towns get cut in half, or a bridge is built and towns merge, or or or ...
Cheers,
Posted Oct 23, 2021 15:38 UTC (Sat)
by nix (subscriber, #2304)
[Link] (1 responses)
I dunno. Even countries newer than the US, like Canada, have examples, some of which involve changes that don't even involve changing the clocks, just the zone. In my (rather old) tzdb copy, Chris Walton says:
# On March 11/2007 most of Canada went onto daylight saving. On March
(The US has examples of single towns where this was contended, so some residents historically followed one timezone and others followed another. As far as I can tell, *anything*, no matter how ludicrous, has been done somewhere, somehow, by someone where timezones are concerned.)
Posted Oct 23, 2021 19:51 UTC (Sat)
by marcH (subscriber, #57642)
[Link]
Exactly why timezones are city based and don't follow state lines.
Was the Kansas metro ever split into more than one timezones? If it ever was, just name the zones after some other cities that were not split.
> I was able # to confirm that Resolute Bay was still operating on UTC-5
Yet no one ever felt the need for a Resolute Bay time zone.
> As far as I can tell, *anything*, no matter how ludicrous, has been done somewhere, somehow, by someone where timezones are concerned.)
Sure but has it ever been a problem finding a(nother) city to name it? Worst case call it west Jerusalem and done.
Posted Sep 29, 2021 15:19 UTC (Wed)
by nilsmeyer (guest, #122604)
[Link] (2 responses)
Given the number of computers running there one might also consider adding Martian time zones to the mix.
Posted Sep 29, 2021 18:10 UTC (Wed)
by Wol (subscriber, #4433)
[Link]
Cheers,
Posted Sep 30, 2021 8:41 UTC (Thu)
by NYKevin (subscriber, #129325)
[Link]
Martian sols are not 24 hours long, so you would need to change the UTC offset every sol (Martian day) to keep it in sync. The least-bad way to do that is probably a set of DST rules configured such that a new DST offset takes effect at the end of each sol, but that would take up a prohibitive number of entries in the tzdb. And I'm not sure if you could even reuse those entries next year, because the Martian calendar would fall out of sync with the terrestrial calendar, so you'd need a new set of DST rules for each year. You could probably write software to automatically generate these entries, but at that point you might as well not use tzdb in the first place.
Posted Sep 29, 2021 8:21 UTC (Wed)
by Cyberax (✭ supporter ✭, #52523)
[Link] (1 responses)
Why the heck "equity" is used to justify all kinds of moronic changes? There's no pressing demand to save a few kilobytes by merging timezones. If you want equity, then just go and put in more TZ entries for underserved territories.
Posted Sep 30, 2021 11:34 UTC (Thu)
by immibis (subscriber, #105511)
[Link]
Posted Sep 29, 2021 15:27 UTC (Wed)
by martin.langhoff (subscriber, #61417)
[Link]
One of the obvious things is to decouple the TZ identifiers from locations – then a specific TZ can have (a) a stable identifier to 'anchor' localizations, and (b) as many alternate names as needed to satisfy cultural and political needs.
A new format might have "transition" pointers -- before X date, use this other TZ, after Y date use this other TZ. All of this will need new infra, but things don't change until you start changing them. And folks agitating for better support can be pulled into porting old software to new libraries.
Needless to say, the legacy format will need to live on (until 2038? ;-) ), but hopefully we don't have to argue too much about it.
Posted Sep 29, 2021 15:28 UTC (Wed)
by martin.langhoff (subscriber, #61417)
[Link]
One of the obvious things is to decouple the TZ identifiers from locations – then a specific TZ can have (a) a stable identifier to 'anchor' localizations, and (b) as many alternate names as needed to satisfy cultural and political needs.
A new format might have "transition" pointers -- before X date, use this other TZ, after Y date use this other TZ. All of this will need new infra, but things don't change until you start changing them. And folks agitating for better support can be pulled into porting old software to new libraries.
Needless to say, the legacy format will need to live on (until 2038? ;-) ), but hopefully we don't have to argue too much about it.
Posted Sep 29, 2021 15:48 UTC (Wed)
by Wol (subscriber, #4433)
[Link] (42 responses)
Meanwhile, Berlin is currently on Moscow time.
Shouldn't the time zone data be kept separate from the location data? And you just have a link from the location to the appropriate time zone. Okay, this does make it a bit difficult to go back from time zone to location, but surely going "Oslo -> CEST -> Berlin" is a stupid thing to do, anyway. Timezone to location is a one->many link and there's no such thing as a definitive answer!
And how does the database cope with towns that have had borders (and timezones) move around them?
So to take the example given, sure let's merge all the post-1970 European stuff into a zone CALLED CEST. Then Oslo could be a link that says "post 1970 -> CEST, pre 1970 -> Norway". And CEST would have nothing to do with Berlin ... :-)
And our hypothetical town on the Norwegian-Finnish border would be a link to "post nnnn -> Norland, pre nnnn -> Finway".
Cheers,
Posted Sep 29, 2021 17:03 UTC (Wed)
by smurf (subscriber, #17840)
[Link] (1 responses)
Europe/Central would be much more appropriate.
NB: At least Samoa gave us more than a week's notice. We should be grateful. Wasn't there some country a few years ago that decided three measly days before the time of the switch?
Posted Sep 29, 2021 21:36 UTC (Wed)
by NYKevin (subscriber, #129325)
[Link]
Posted Sep 29, 2021 17:45 UTC (Wed)
by NYKevin (subscriber, #129325)
[Link] (39 responses)
The problem with giving timezones names is that you basically have a bunch of bad options, and no obvious "right" option:
The Olson database goes with the Continent/City notation, mostly because it is supposed to require the least amount of localization work (just need the localized name of each city and continent) and is unlikely to run into issues of disputed sovereignty etc. As for "Berlin is CEST," they try to solve that problem by offering aliases (so you can just as well pick "Stockholm" or "Paris" or whatever you fancy, and still get correct local civil time), but some people find this unsatisfactory for the reasons explained in the article.
Posted Sep 29, 2021 18:17 UTC (Wed)
by Wol (subscriber, #4433)
[Link] (1 responses)
:-)
In London, we're currently on BST. But that's not (the "official" one) Bering Straits Time.
Cheers,
Posted Sep 29, 2021 23:09 UTC (Wed)
by nowster (subscriber, #67)
[Link]
http://www.irishstatutebook.ie/eli/1971/act/17/enacted/en...
Posted Sep 30, 2021 15:38 UTC (Thu)
by nim-nim (subscriber, #34454)
[Link] (34 responses)
There is an obvious good option – use country for countries that do not span multiple zones, and country/local-zone-name for the others.
Do not allocate a territory to some state that does not control it, do not invent zone names the locals do not use or understand, do not try to reform the whole planet to make it follow some kind of funky rule you invented before breakfast. If people in some part of the world can not agree on who owns what, alias both names and let them settle things by themselves.
All the funky rules you can invent will pour oil on the fire by favoring one party over another, just say no and leave politics to politicians, activists and other people that care nothing about time zones except as a pawn in some other game.
Posted Sep 30, 2021 16:48 UTC (Thu)
by Wol (subscriber, #4433)
[Link]
> There is an obvious good option – use country for countries that do not span multiple zones, and country/local-zone-name for the others.
Exactly. Well, actually, call the time zone whatever the locals call it, prefixed by the 2-letter iso country designation (with exceptions for whatever the country code exceptions are) so we'd have UK-GMT, EU-CET, US-MST. (Along with UK-BST, RU-BST and US-BST ... :-)
Then each of the place links says which timezone is valid for what times.
Half the problem seems to be the maintainer's confusion as to the difference between a timezone, a place, and a political jurisdiction. You CANNOT store accurate data if you do not account for all three separately.
(And this seems to be why people are upset - that the data is being corrupted ...)
Cheers,
Posted Sep 30, 2021 16:55 UTC (Thu)
by NYKevin (subscriber, #129325)
[Link] (32 responses)
Then you have to decide whether Kosovo, South Ossetia, Taiwan, etc. are "countries" or not. Also, according to https://en.wikipedia.org/wiki/List_of_states_with_limited..., at least one UN member does not recognize each of China (PRC), Israel, (South) Korea, (North) Korea, Cyprus, and Armenia, despite the fact that all of those countries are themselves UN members.
OTOH the "city" paradigm runs into Jerusalem (which may or may not have two timezones depending on who you ask, what religion they follow, how they feel about the one/two state solutions etc.). But that sort of dispute over individual cities seems to be much rarer than disputes over larger territories.
Posted Sep 30, 2021 17:30 UTC (Thu)
by Wol (subscriber, #4433)
[Link] (18 responses)
As said elsewhere, what do the LOCALS think? And if they can't decide, provide both.
I believe the ISO system is pragmatic, just use that - hence EU, UK, various other country codes ...
Cheers,
Posted Sep 30, 2021 17:41 UTC (Thu)
by NYKevin (subscriber, #129325)
[Link] (17 responses)
Also, UK is not an ISO country code. The code for the United Kingdom is GB. The .uk TLD was allocated by IANA as a favor to the UK (mostly because they had already been using it before the ccTLD system existed). ISO had nothing to do with that.
Posted Sep 30, 2021 21:45 UTC (Thu)
by Wol (subscriber, #4433)
[Link] (16 responses)
Who is actually in charge of the tzdb? ISO? IANA?
(And yes I know all about UK not being an ISO code. After all, it's the suffix on my email address! And I know all about Ukraine wanting UK as their ISO code until they discovered it was blocked ... I had a Ukrainian girlfriend for a while.)
Cheers,
Posted Oct 1, 2021 1:06 UTC (Fri)
by NYKevin (subscriber, #129325)
[Link] (15 responses)
I may have mixed up IANA and ICANN (one of them does IP addresses and the other does domain names, and I can never keep them straight in my head), but essentially yes. EU and UK are both "exceptionally reserved" by ISO to avoid confusion, but are not considered ISO codes. The DNS people made exceptions for both of them, in part because they were already reserved on the ISO side, and in part because they didn't really have a good reason to say "no."
Also of note: ISO assigns codes to several jurisdictions which nobody thinks of as a "country," such as Puerto Rico (there is an active movement for US statehood, but nobody seriously claims that Puerto Rico is independent of the US, either de facto or de jure). Oddly, this includes Antarctica, which isn't really a "jurisdiction" at all (there is no permanent, continent-wide governing authority, and the authority of governments to enforce laws within their respective territorial claims is limited by the terms of the Antarctic Treaty System). In practice, Antarctica uses UTC regardless of longitude, so we can arguably just ignore it, but it is on the list.
The ISO standard does include a flag which indicates whether the UN considers each jurisdiction to be "independent" or not, so you can just ignore the non-independent ones if you like. Taiwan, as you might expect, is flagged as non-independent, because that's the official position of the UN. ISO does not provide any other means of distinguishing between "a country" and "not a country," so if you want to call Taiwan a country and Antarctica (or Puerto Rico) not a country, you have to come up with your own list instead of using ISO's list.
> And again, what happens with historical data? I don't know when ISO_3166 was started, but Austro-Hungary probably never had a ISO code, but could possibly have had summer time.
Which is yet another reason to avoid using ISO codes and just use Continent/City, as tzdb does. Europe/Vienna still exists today. A hypothetical ISO-based Austria-Hungary timezone, however, would've had to be migrated at some point, as ISO has a policy of releasing codes once they are no longer used. Such codes are reserved for quite a long time in most cases, but can eventually be reassigned to another country. OTOH, they reassigned RU from the USSR to the Russian Federation rather quickly, because the latter is recognized as the successor state of the former. This would have broken the timezones of various former Soviet Republics, if using an ISO-based timezone scheme.
(I have no idea what the timezone of Austria-Hungary was, but Wikipedia says that DST was actually invented in Germany and Austria-Hungary, at least at a national scope, anyway. So yes, they did have DST rules.)
> Who is actually in charge of the tzdb? ISO? IANA?
tzdb is nominally "organized" by ICANN, but in practice I believe it operates much like a standard FOSS project.
Posted Oct 1, 2021 17:12 UTC (Fri)
by Wol (subscriber, #4433)
[Link] (14 responses)
Not for the political entity that defines what the timezone is!
GMT/BST is defined by the UK government. Portugal, and South Africa, while both lying on the Prime Meridian, use different time zones, Portugal I believe is on CET, South Africa I don't have a clue.
Continent/City should be used to SELECT which time zone(s) apply. From my point of view, I couldn't care whether it's UK/Greenwich, England/London, Scotland/Edinbugh or what. That would contain a link to a timezone of GB-GMT.
But, to pick on a country I've mentioned, When did Portugal switch from local (GMT) to CET time? Portugal/Lisbon should NOT return the time zone data for Berlin because at some time in the not so distant past it was different.
So if the user selects Portugal/Lisbon, it should say something like "1970-present EU-CET, pre-1970 PT-PST" (for poruguese standard time or whatever they called it before they went on to CET.
At the end of the day, location and time zone are two completely different things, and SHOULD NOT be referred to by the same identifier.
Cheers,
Posted Oct 1, 2021 18:06 UTC (Fri)
by mpr22 (subscriber, #60784)
[Link]
No part of the Portuguese mainland lies on or east of the Prime Meridian, and large parts of it lie west of 7.5°W.
No part of the South African mainland is less than 15°E of the Prime Meridian. Cape Town, which isn't quite the westernmost point but is certainly the westernmost major city, is 18°E. Johannesburg and Pretoria are 28°E, Pietermaritzburg is 30°E, Durban is 31°E, and South African Standard Time, used nationwide, is entirely sensibly UTC+0200 year-round (there is no DST in South Africa).
> When did Portugal switch from local (GMT) to CET time?
Portugal is currently, and was historically, on WET (UTC+0000 / +0100).
Between 1966-76 and 1992-1996, Portugal was on CET (UTC+0100 winter time).
And in Lisbon (9°W), the mean solar azimuth at 12:00 standard time / 13:00 DST over the course of the year tells you that you should be on UTC-0100 / +0000 if using one-hour-aligned time zones.
Posted Oct 2, 2021 20:08 UTC (Sat)
by NYKevin (subscriber, #129325)
[Link] (12 responses)
Posted Oct 2, 2021 20:24 UTC (Sat)
by Wol (subscriber, #4433)
[Link]
More to the point, it does NOT work for Europe. Timezones and political jurisdictions do NOT align, so don't use the same key to reference both. Likewise, it doesn't work for the US. Just because multiple US states. and multiple EU countries have *chosen* to share a time zone, doesn't mean things won't change. There is a lot of talk about Britain going on to CET/CEST, but the Scots in particular are extremely unhappy about that.
If the TIMEZONE is independent from the POLITICAL, then if England/London decides to change while Scotland/Edinburgh doesn't, then separating timezone from location makes the change dead simple. If the timezone is called Britain/London, it's a lot more involved.
Cheers,
Posted Oct 2, 2021 20:41 UTC (Sat)
by Wol (subscriber, #4433)
[Link] (10 responses)
Data Integrity?
After all, isn't the big complaint about this change that it is CORRUPTING HISTORICAL DATA.
Rule One of data integrity, Do Not Store Unrelated Data In The Same Table. If you mix time data and location data (as is being pushed here) you are doing exactly that!
You store your timezones in one table, and you store your locations in a separate table. Then you have a link that contains location, dates, and timezones, that says which timezone applies where and when. At which point your database is robust and resistant to political screw-ups.
Unlike the present mess where the maintainer is wilfully trashing the historical information, and setting the system up for a major mess if countries decide to shift timezones - as indeed the UK has been talking about doing ...
(I'm a database guy. I dislike relational because it insists you splat data referring to one object across multiple tables, which causes loads of trouble. But the opposite also holds - plonking data referring to multiple objects in one table causes just as much if not more trouble!)
Cheers,
Posted Oct 3, 2021 4:51 UTC (Sun)
by NYKevin (subscriber, #129325)
[Link] (9 responses)
* A UTC offset is a (possibly fractional) signed number, usually written as e.g. UTC+5 (or whatever number you want).
tzdb does not mix those two types of object up. It is very clearly structured as mapping timezones to UTC offsets (or more specifically, to lists of offsets along with the dates and times when those offsets went into effect). Therefore, I can only surmise that you are talking about yet another type of object, which is not listed above, but I simply cannot visualize such an object as relevant to the problem at hand.
The whole point of tzdb is that you pick e.g. Europe/Berlin, or Europe/Paris, or America/New_York, or whatever you fancy, and then it tracks the local time in that city indefinitely into the future, regardless of geopolitical upheaval. It is very deliberately jurisdiction-agnostic. Imagine, for a moment, that tzdb was around before World War I. Then Europe/Vienna would have tracked Austro-Hungarian law on DST etc., and everyone in the Vienna metropolitan area would be following the Europe/Vienna timezone. Similarly, everyone in the Budapest metro area would be following Europe/Budapest, which would also track Austro-Hungarian law. After the war, Austria-Hungary ceased to exist, and therefore Europe/Vienna would have transparently updated to follow Austrian law, and Europe/Budapest would have transparently updated to follow Hungarian law.
Under your proposal, everyone would need to go into their settings and switch from the no-longer-existent Austria-Hungary to the Austrian jurisdiction or Hungarian jurisdiction explicitly. Or else some piece of software would have to figure out whether the user is now Austrian or now Hungarian, and update the settings without telling the user, and we would have to hope it got it right. But under the tzdb system, everything Just Works™ because the timezones were never tied to jurisdictions in the first place.
In short: You are proposing the addition of a third type of data, and I still don't understand what that type is intended to accomplish, in terms of solving a real-world problem that is not already solved by the existing system. It's fine to talk about normalization, but this schema is already normalized.
Posted Oct 3, 2021 7:07 UTC (Sun)
by smurf (subscriber, #17840)
[Link] (7 responses)
Yeah, that is/was the idea. The whole brouhaha we're discussing here originates in the brain-dead (IMHO) idea that right now Europe/Stockholm and Europe/Berlin are the same, and Berlin is larger than Stockholm, so the tzdb maintainer feels free to alias the former to the latter – regardless of the fact that this is not historically correct. Plus, if Stockholm ever decides to diverge from Berlin's rules in the future, a rather inconveniently large number of Swedes will need to update their tzdb and then manually fix their timezone settings.
Posted Oct 3, 2021 18:47 UTC (Sun)
by Wol (subscriber, #4433)
[Link] (1 responses)
Now let's throw in the FACT that - even right now - Berlin does not have the authority to decide what timezone Stockholm follows, and aliasing Berlin to Stockholm is just plain stupid.
Okay. Let's (for the sake of convenience/accuracy/whatever) call our base timezones "Meridian0" or "Meridian150W" or "Meridian900E" etc. (I've multiplied latitude by 10 so it makes half-hour zones easier - go back to 1800 or so and Bristol would have been "Meridian75W" by that standard...)
Then we have the POLITICAL AUTHORITY that sets summer time - probably the EU that says "Summertime starts last Sunday in March, ends last Sunday in October, at 0100 Meridian150W" - lets call those rules EU-EST.
And lastly we have Sweden/Stockholm that says "base meridian is Meridian150W, Daylight saving is EU-EST, applies 1970 onwards" or whatever.
Then if a country decides to change timezone, eg the UK shifts to European time, we just change Britain/London to say Meridian0 until 2024, Meridian150W from 2025, EU-EST applies from 1970 onwards".
As smurf says, the idiocy is in keying a bunch of TIMEZONE data on a city LOCATION. Which fucks up any other cities that just happen at present to be in the same time zone. Imagine what grief it's going to cause if Britain DOES go onto CET/CEST and tzdb changes our timezone to Berlin ... (or rather, changes Berlin time to London!!!)
Cheers,
Posted Oct 3, 2021 19:10 UTC (Sun)
by amacater (subscriber, #790)
[Link]
Posted Oct 3, 2021 19:50 UTC (Sun)
by jrn (subscriber, #64214)
[Link] (4 responses)
I agree about needing to update tzdb (this is a fact of life in all jurisdictions, since we cannot predict the future), but why would they need to update their settings instead of continuing to use Stockholm like they were already doing? It's not like this tzdata update makes "TZ=Europe/Stockholm" stop working.
Posted Oct 3, 2021 22:36 UTC (Sun)
by Wol (subscriber, #4433)
[Link] (2 responses)
Because this change means that the real Stockholm will be deleted and lost.
Which means that the historical data used for Stockholm will actually be the data for Berlin (which may, or may not, be the same).
Cheers,
Posted Oct 4, 2021 18:40 UTC (Mon)
by smurf (subscriber, #17840)
[Link]
Posted Oct 4, 2021 22:28 UTC (Mon)
by anselm (subscriber, #2796)
[Link]
Right now, two minutes with zdump should make it obvious that they're emphatically not the same.
Posted Oct 4, 2021 18:47 UTC (Mon)
by smurf (subscriber, #17840)
[Link]
And since neither Eggbert nor anybody else can predict whether that alias holds in the future, adding such an alias is Just Plain Wrong.
Posted Oct 4, 2021 12:30 UTC (Mon)
by Wol (subscriber, #4433)
[Link]
The problem, timezones are NOT jurisdiction-agnostic.
LOCAL (ie solar) time is jurisdiction-agnostic. But it's the politicians who decide what timezone applies to the country as a whole. They might like to think their jurisdiction extends to the sun, but I think I know who (or what) would win THAT battle :-)
Cheers,
Posted Sep 30, 2021 18:50 UTC (Thu)
by nim-nim (subscriber, #34454)
[Link] (12 responses)
Thus, you *can* *not* wipe out those territories to please someone’s idea of political border even if you wanted to.
And then making both version of ownership exist at the same time is just a matter of aliasing as long as you’re smart enough to make all aliases point to a neutral key (for example a longitude+indice value) and not the name of someone else’s capital.
Posted Sep 30, 2021 20:34 UTC (Thu)
by NYKevin (subscriber, #129325)
[Link] (11 responses)
This is why cities are (usually) superior to countries (except for Jerusalem, which is a whole other level of political-messed-upness).
> And then making both version of ownership exist at the same time is just a matter of aliasing as long as you’re smart enough to make all aliases point to a neutral key (for example a longitude+indice value) and not the name of someone else’s capital.
That breaks on Jerusalem just as much as calling it "Jerusalem" would. The problem is that the individual people living within the city go by different timezones depending on their nationality and the extent to which they personally recognize Israeli jurisdiction over the city. You can't lat/long your way out of that. If you try using numerical indices, then somebody has to be "first" and somebody has to be "second," and they'll argue over that instead.
Posted Oct 1, 2021 2:00 UTC (Fri)
by nybble41 (subscriber, #55106)
[Link] (3 responses)
Posted Oct 1, 2021 6:59 UTC (Fri)
by NYKevin (subscriber, #129325)
[Link] (2 responses)
Also, anybody can register a domain name. You have to have a more selective set of criteria than that. If you go by "does it have a ccTLD?" then you're right back to ISO country codes, but now they're wearing a funny hat.
Posted Oct 1, 2021 15:32 UTC (Fri)
by nybble41 (subscriber, #55106)
[Link] (1 responses)
If they can afford to publish rules about their time zone then they can afford a few dollars a month for a domain name and some shared hosting capacity.
> Also, anybody can register a domain name.
Sure, and that's kind of the point. There should be some notability threshold for pulling the data into the collated time-zone database, just as a spam prevention measure, but I see no reason whatsoever to impose any further limits on who can publish time-zone information. If there are real people following the time zones some organization publishes then that organization's zones should be listed.
Posted Oct 10, 2021 0:40 UTC (Sun)
by flussence (guest, #85566)
[Link]
Posted Oct 1, 2021 8:19 UTC (Fri)
by nim-nim (subscriber, #34454)
[Link] (5 responses)
The indice of the zone aliased to would be the same.
Because *operationally*, even if people disagree on who owns what, trains still have to leave on time, schoolchildren still have to go to school on time, so there is only one timezone in operation at any given time in a particular territory.
So the *correct* answer to cases like Taiwan is to have
Which is *exactly* the reverse of the TSDB move.
In real life you do not resolve arguments Salomons’ way with rash decisions everyone disagrees with (moreso when you *ability* to make fictitious grouping exist is nil). You resolve arguments by giving something to every party.
Especially in IT where aliases and indirections are the norm.
Posted Oct 2, 2021 20:02 UTC (Sat)
by NYKevin (subscriber, #129325)
[Link] (4 responses)
This is incorrect. In Jerusalem, they *don't* agree on what the local time is (or, to be more precise, they don't agree on exactly when DST begins and ends). This *does* cause the exact disruptions you identify, and yet they disagree anyway. The same is also applicable to some of the western regions of China (because China insists on having one timezone for the whole country, despite the country being far too wide for this to make logical sense), where different communities are on different offsets and will informally indicate times as "local" or "Beijing" time (the "local" timezone doesn't officially exist, so it's not in tzdb, but people use it).
Posted Oct 2, 2021 22:36 UTC (Sat)
by mathstuf (subscriber, #69389)
[Link] (1 responses)
AFAIU (based on podcast data), it actually differs based on the language being spoken (rather than being explicitly labeled as such). Speaking Chinese, time is Beijing-offset. Speaking the local language, time offsets are a more sensible offset.
Posted Oct 3, 2021 4:54 UTC (Sun)
by NYKevin (subscriber, #129325)
[Link]
Posted Oct 3, 2021 8:48 UTC (Sun)
by ghane (guest, #1805)
[Link]
https://en.wikipedia.org/wiki/Xinjiang_Time
Posted Oct 4, 2021 13:35 UTC (Mon)
by nim-nim (subscriber, #34454)
[Link]
People can disagree on what zone the entity that schedules trains should use to display scheduling but this entity is most definitely knows what timezone it uses for scheduling decisions.
There is a strong temptation to roundtrip between physical location, timezone and political authority. That does not work. That will never work. It’s not a one-to-one relationship.
Labeling timezones with city names (and worse, country capital names) is horrible because it assumes this one-to-one relationship.
Posted Oct 3, 2021 18:45 UTC (Sun)
by marcH (subscriber, #57642)
[Link]
Wait... if they can agree on neither the time nor _the name of the city_ then there is no problem: just use those different names and problem solved! No?
Posted Oct 1, 2021 15:01 UTC (Fri)
by mcopple (subscriber, #2920)
[Link] (1 responses)
And that doesn't even count political sub-units that also have multiple timezones (e.g., Indiana, which has 18 or so counties in central time zone because they are part of the Chicago metro, and the rest in the eastern time zone -- I used to dread the daylight savings time change because we always had some complication).
Posted Oct 1, 2021 17:19 UTC (Fri)
by Wol (subscriber, #4433)
[Link]
Name the time zone after the political entity responsible, then create as many country/state/city combos as the locals want/need, that link to the relevant time zones that apply to that area.
Most of this angst is becasue the time zone is being given a country/city designation which screws everybody except the cityzens of that city.
Cheers,
Posted Sep 29, 2021 17:15 UTC (Wed)
by jhoblitt (subscriber, #77733)
[Link]
My expectation as an end user is that new releases mostly add modern dst transitions. Potentially breaking date/time calculations of existing and long stable zones seems fundimentally wrong. Such a major change warrants a major version bump. IOW - zoneinfo2 However, my preference would be to see a more flexible system that doesn't rely on the symlinks that have caused the current crisis.
Posted Sep 29, 2021 19:04 UTC (Wed)
by dcantrell (subscriber, #75800)
[Link]
Posted Sep 30, 2021 0:14 UTC (Thu)
by jkingweb (subscriber, #113039)
[Link]
The article didn't give me the impression that this has long been a bone of contention, nor that further discussion couldn't yield an acceptable alternative, assuming Eggert is willing to entertain alternatives, so the urgency confuses me.
I don't envy the task of keeping up with timezones, anyway. It seems like a thankless, Sisyphean enterprise to me.
Posted Sep 30, 2021 2:04 UTC (Thu)
by itsmycpu (guest, #139639)
[Link]
Perhaps it could be done somehow like this (just as a vague idea):
a) The software will remember and the code above will still print "Europe/Stockholm"
So that "Europe/Stockholm" will not inherit pre-1970 data that does not apply and would be wrong. So that the numbers don't lie.
Posted Sep 30, 2021 6:45 UTC (Thu)
by kunitz (subscriber, #3965)
[Link]
Two TZDB versions one 1970-and-after and another 1870-and-after would make a lot of sense. The latter could then cover Hamburg and Munich as well.
Posted Sep 30, 2021 9:14 UTC (Thu)
by aurel32 (subscriber, #7059)
[Link] (3 responses)
Upstream and a few supporters on the mailing list have a very US-centric view there, the fact that there is not one timezone per US state is used as an argument to say that there is no need for one timezone per ISO-3166 country.
Posted Sep 30, 2021 9:31 UTC (Thu)
by aurel32 (subscriber, #7059)
[Link]
Posted Sep 30, 2021 12:34 UTC (Thu)
by jkingweb (subscriber, #113039)
[Link]
Americans tend to be the focus of attention, but it happens in multiple federal countries.
Posted Sep 30, 2021 18:07 UTC (Thu)
by NYKevin (subscriber, #129325)
[Link]
* Google gives deceptively similar numbers for me, but then I realized that one is in miles and the other is in kilometers.
Posted Sep 30, 2021 22:31 UTC (Thu)
by Comet (subscriber, #11646)
[Link]
Posted Oct 3, 2021 19:02 UTC (Sun)
by marcH (subscriber, #57642)
[Link]
Reality check: the computer industry has been historically rooted in the Western world and there are more people in Europe likely to notice this sort of semi-obscure regressions than in Angola or Niger.
> Unfortunately, the equity issue has broadened and is now visible outside our little community, and I really and sincerely doubt whether it'd be a good idea for us to do nothing about it now. We need to establish that we are fixing the problem and are not deferring action to a never-never land of arcane bureaucracy, and we need to do so in terms that will be clear to outsiders.
Reverting some of the earlier changes and separating say Angola and Niger would have been a great demonstration to (hidden and mysterious?) "outsiders".
> There are ways to derive the two different views into the data, Colebourne said, but that requires keeping the existing data in the main database file. That file can be processed to automatically do the merges as Eggert wants, but that the reverse is not true, Colebourne said
You'd think this should be obvious to a computer science professor.
Posted Apr 29, 2022 23:23 UTC (Fri)
by moxfyre (guest, #13847)
[Link]
… and your wrongness has nothing to do with timezones, databases, Norway, Sweden, or 1970. 😬
A fork for the time-zone database?
* Cherry-pick patches from tadata-2021b until the upstream situation gets less confused:
- 01-no-leap-second-2021-12-31.patch: No leap second on 2021-12-31 as per IERS Bulletin C 62.
- 02-samoa-dst.patch: Samoa no longer observes DST.
- 03-jordan-dst.patch: Jordan now starts DST on February's last Thursday.
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Wol
Normalizing on UTC
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Astrology
Wol
Astrology
Astrology
Astrology
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
So yes, combining all CEST-using countries into a single one is very short-sighted.
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
12:00:00.000 precisely - ???
12:00:00.001 - after midday, so definitely "pm" (post meridiem)
A fork for the time-zone database?
A fork for the time-zone database?
- "11am" = 11+0 = 11
- "12pm" = 12+12 = 24 --- wtf?
- "1pm" = 1+12 = 13
A fork for the time-zone database?
* 1-11:xx = 1-11:xx AM (obvious)
* 12:xx = 12:xx PM (obvious once you have the first rule memorized)
* 13:xx = 1:xx PM (13 is not composite, neither is 1)
* 14:xx = 2:xx PM (14 is even)
* 15:xx = 3:xx PM (15 is divisible by 3)
* 16:xx = 4:xx PM (16 = 4²)
* 17:xx = 5:xx PM (17 and 5 are both prime)
* 18:xx = 6:xx PM (18 is divisible by 6)
* 19:xx = 7:xx PM (19 and 7 are both prime)
* 20:xx = 8:xx PM (20 and 8 are both divisible by 4)
* 21:xx = 9:xx PM (21 and 9 are both divisible by 3)
* 22:xx = 10:xx PM (22 and 10 are both even)
* 23:xx = 11:xx PM (23 and 11 are both prime)
* 24:xx doesn't exist. Some people write 24:00 to mean 0:00, but at the end of the day instead of the beginning of the day.
A fork for the time-zone database?
* 1-11:xx = 1-11:xx AM (obvious)
* 12:xx = 12:xx PM (obvious once you have the first rule memorized)
* everything else: subtract 12, put 'PM' after it
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
> So how does that help "from 16:00 to 00:30"
>Understood but I don't remember seeing that anywhere I've been.
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
The most ironic is this federal strong-arming was performed by the "government-is-the-problem" president. But you know, there are "cases where overwhelming needs...". Like for instance being married to the "war-on-drugs" first lady?
A fork for the time-zone database?
Somebody have multiple given names (for example, one at birth and another one when they become adult)
A fork for the time-zone database?
Wol
A fork for the time-zone database?
to computers but humans will break any assumptions you may make. In Hong Kong, for example, it's complex: https://culturalatlas.sbs.com.au/hong-kong-culture/hong-k...
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
There's also a "Falsehoods Programmers believe about Gender" list which contains similar mistakes and eye-opening (or eye-watering for that matter) "Designing forms for gender diversity and inclusion".
A fork for the time-zone database?
and we have
Christian name(s), (patronymical) surname.
Wol
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
1 Some Street
Town
County
Postcode
1 Some Street
The Other Street
Town
County
Postcode
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Picking from a map helps by giving people a visual reference, but some people are also very bad at maps.
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Hmm...I think I remember this "travel" thing of which you speak...
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
interace is probably a list.
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
>
> The time zone map met a similar fate. The Indian government threatened to ban all Microsoft software from the country because we assigned a disputed region to Pakistan in the time zone map. (Any map that depicts an unfavorable border must bear a government stamp warning the end-user that the borders are incorrect. You can’t stamp software.) We had to make a special version of Windows 95 for them.
A fork for the time-zone database?
A fork for the time-zone database?
Well, they're still trying... (Note the mentions of Jerusalem in other comments).
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
# 14/2007 I phoned the Resolute Bay hamlet office to do a "time check." I
# talked to somebody that was both knowledgeable and helpful. I was able
# to confirm that Resolute Bay was still operating on UTC-5. It was
# explained to me that Resolute Bay had been on the Eastern Time zone
# (EST) in the winter, and was now back on the Central Time zone (CDT).
# i.e. the time zone had changed twice in the last year but the clocks
# had not moved. The residents had to know which time zone they were in
# so they could follow the correct TV schedule...
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
Wol
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
Wol
London is on Berlin time?
* A timezone is a set of rules for deciding which offset to use. tzdb uses names such as Europe/Berlin for them, but there are a variety of other names you could use instead (CET/CEST, "Central European Time", etc.).
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
Which means that the historical data used for Stockholm will actually be the data for Berlin (which may, or may not, be the same).
London is on Berlin time?
London is on Berlin time?
Wol
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
China/Taiwan and Taiwan exist at the same time in the database as aliases and point to a technical neutral key like 121.some_indice
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
London is on Berlin time?
Wol
A fork for the time-zone database?
Solution: make everyone unhappy
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
>
> DateTimeZone zone = DateTimeZone.forID("Europe/Stockholm");
> System.out.println(zone);
>
> will print "Europe/Berlin" if this change is not reverted. I consider this to be catastrophic.
b) It seems that patch uses an all-inclusive reference from "Europe/Stockholm" to "Europe/Berlin". Instead, it will have references limited by date ranges (for example >= 1970). Perhaps any references without date range would be limited to >= 1970 by default.
Correct time zone history for Oslo and Stockholm but not for Hamburg and Munich?
A fork for the time-zone database?
A fork for the time-zone database?
http://mm.icann.org/pipermail/tz/2021-September/030464.html
http://mm.icann.org/pipermail/tz/2021-September/030469.html
http://mm.icann.org/pipermail/tz/2021-September/030470.html
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
A fork for the time-zone database?
If you’re relying on the timezone database to carefully distinguish the timestamps of pre-1970 events in Norway vs. Sweden for astrological purposes then You're Doing It Wrong…“Historical data is mostly only used by astrology programs”