A new date standard?
-
Well, that's better than the stupid MM-DD-YYYY, but the only way you can properly sort is YYYY-MM-DDD
-
I am not aware that the way numbers are written (and hence sorted) are different in those languages. AFAIK, multi digit numbers are actually written at least in Arabic left to right still...
-
I am not aware that the way numbers are written (and hence sorted) are different in those languages. AFAIK, multi digit numbers are actually written at least in Arabic left to right still...
As someone who knows Arabic, you are correct. As someone who has never used an Arabic keyboard for sorting, I would assume that sorting follows the language, which in this case is right to left. So DD-MM-YYYY would sort in the order of 78-56-1234 since the numbers are left to right, but higher precedence from right number to left.
-
Now that you mention it I have never seen or read a reference to year 0. Hmmm
I may not be that good looking, or athletic, or funny, or talented, or smart I forgot where I was going with this but I do know I love bacon!
The conspiracy theorists probably submit that the Vatican has deliberately done this in order to prevent the masses from learning the truth about whatever it is they might be hiding. We're philosophical about power outages here. A.C. come, A.C. go.
-
As someone who knows Arabic, you are correct. As someone who has never used an Arabic keyboard for sorting, I would assume that sorting follows the language, which in this case is right to left. So DD-MM-YYYY would sort in the order of 78-56-1234 since the numbers are left to right, but higher precedence from right number to left.
In any case, why would you sort a date as a string? We're philosophical about power outages here. A.C. come, A.C. go.
-
In any case, why would you sort a date as a string? We're philosophical about power outages here. A.C. come, A.C. go.
-
In any case, why would you sort a date as a string? We're philosophical about power outages here. A.C. come, A.C. go.
-
The conspiracy theorists probably submit that the Vatican has deliberately done this in order to prevent the masses from learning the truth about whatever it is they might be hiding. We're philosophical about power outages here. A.C. come, A.C. go.
I'm sure, all those lonely knights?
I may not be that good looking, or athletic, or funny, or talented, or smart I forgot where I was going with this but I do know I love bacon!
-
Yes. I take your point. My issue is with a recent employer who insisted on storing dates as integers or strings or even decimals in his database. I can't remember seeing a single DateTime or Date object. See where I'm coming from? We're philosophical about power outages here. A.C. come, A.C. go.
-
Mike Hankey wrote:
1 BCE?
or maybe 2 BCE? When Y2K was a hot topic, I was surprised to learn that the church (at least the protestant ones, but I assume that catholic ones agree, and then the other (Christian) ones follow suit) have a discontinuous time line: Year 1 BC is immediately followed by year 1 AD, with no intermediate year 0. So the question is if the time format used here has a year 0. We must assume that value 1 is AD (or if you like: CE), but is a value of 0 then 1 BC, and a value of -1 consequently 2 BC? Or is value 0 illegal? I was surprised to read in Wikipedia that the numerical value of AD/BC and CE are identical, with "400 BCE corresponds to 400 BC" explicitly given as an example. So the CE concept has adopted a discontinuous number line for labeling years. It is kind of curious that in an attempt to mark an independence from religion defined time scales, still we stick to a highly religion defined number line, rather than a mathematical one. Maybe it has to do with the zero being invented by the Arabs, and as we all know, their culture is not quite as we want it to be, so we reject it. What I am now waiting for is some (secular) standard that requires 1 = 3.
Member 7989122 wrote:
zero being invented by the ArabsIndians,
FTFY [Who Invented Zero?](https://www.livescience.com/27853-who-invented-zero.html) At least the first who actually used it as the zero concept we have today, instead of just a placeholder so they didn't confuse themselves when writing down a number.
