The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
If a date value is initialized to all 1 bits, and you interpret it as numeric subfields, 111...11 is -1. So the year comes out as -1. Now for the month, nubered from 0 and upwards, January is month 0. -1 is the month before that, which is December. We go on to the date field: 0 is the first day of the month, and -1 is one day earlier. We were in December, and go one day back: That brings us to November 30th.
Which is the value that you've got. Date -1 of month -1 of year -1 comes out formatted exactly the way you saw it.
I think it would have been more correct if the year was -0002: Like the date -1 pulls the month from December back to November, the month -1 should have pulled the year back to -0002. I read an article about this a few weeks ago (now I pity that I didn't save the URL!) telling that one of the most widespread libraries used for formatting in the *nix world doesn't do that; it gives exactly the value 30-11--0001 for an input of all bits set.
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.
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.
Over here Halloween is getting more and more popular, today we biked past Walibi and were amazed how busy it was, more info here: Halloween Fright Nights | Walibi Holland[^]
All in all we were amazed at the amount of attractions in this quiet eastern part of our province of Flevoland in the Netherlands, there's even an artificial ice skating rink "Flevonice" (not opened yet for skating, but there are other attractions).
If you have kids, the pancake restaurant "Hans&Grietje" is recommended too, but watch out for the witch, the tables can behave strangely too