A new date standard?
-
So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
1 BCE?
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!
-
1 BCE?
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!
Unless they're using the Xiqorcian calendar :)
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
Unless they're using the Xiqorcian calendar :)
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
That's a whole lot of words for "add another digit" :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
Sander Rossel wrote:
"add another digit"
...only when necessary!
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.
-
None, I got the hell out of there :laugh:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
Just place as much orders for that date as possible. Stuff from this era will be worth a lot by then, and you have time enough to save for the bill :thumbsup:
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
Or Mayan calendar which would be 7.17.18.10.10
Isn't that an IP address? :laugh:
Sent from my Amstrad PC 1640 Never throw anything away, Griff Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt -
Isn't that an IP address? :laugh:
Sent from my Amstrad PC 1640 Never throw anything away, Griff Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
WouldntYaWantToBeAMayan.com I believe?
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!
-
WouldntYaWantToBeAMayan.com I believe?
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!
-
Sander Rossel wrote:
"add another digit"
...only when necessary!
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.
By mutual agreement of the partners in the interchange?
-
So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
ISO 8601 or go home.
-
So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
Quote:
for Americans, that's the logical order of day-month--year
:confused: What I think to remember and described here "In the United States, dates are traditionally written in the "month-day-year" order: Date and time notation in the United States - Wikipedia[^]
It does not solve my Problem, but it answers my question
-
So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
None, I got the hell out of there :laugh:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
Sander Rossel wrote:
I got the hell out of there
What you don't trust a site that stores it's dates a strings?
Never underestimate the power of human stupidity RAH
-
So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
Isn't that an IP address? :laugh:
Sent from my Amstrad PC 1640 Never throw anything away, Griff Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
Its an IP address of a point in time! :laugh: :laugh: :laugh:
-
So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
This is format dd-MM-uuuu, where the year may be negative: -1 here, as opposed to yyyy. Maybe a hotel reservation in Bethlehem.
-
So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
Sander Rossel wrote:
(for Americans, that's the logical order of day-month--year).
That's the typical Eurocentric ass-backwards mindset. YYYYMMDD, with whatever delimiters float you boat. As for the US Vernacular, most conversations would say something like October 25th or June 2nd. The year is only necessary, in conversations, a fraction of the time. So - the dates are written as they are said. But, as far as it goes, it's no worse for sorting (even when numeric) than the crappy Euro-convention. At least, if all in the same year, the US convention MM-DD would sort correctly (small consolation).
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010
-
1 BCE?
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!
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.
-
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.
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!
-
So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
The year value -1 should have tipped you off. 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.
