Difference between revisions of "Talk:2676: Historical Dates"

Explain xkcd: It's 'cause you're dumb.
Jump to: navigation, search
(Introducing zero Julian date question.)
Line 41: Line 41:
  
 
My first thoughts when reading this comic was that 30 Dec 1899 was the last business day of the 19th century, and that thousands (or millions) of people were selling their worldy assets, in the mistaken belief that the world would come to an end (sort of like a Y2K scare, but without the tech).  [[User:Beechmere|Beechmere]] ([[User talk:Beechmere|talk]]) 03:29, 26 September 2022 (UTC)Beechmere
 
My first thoughts when reading this comic was that 30 Dec 1899 was the last business day of the 19th century, and that thousands (or millions) of people were selling their worldy assets, in the mistaken belief that the world would come to an end (sort of like a Y2K scare, but without the tech).  [[User:Beechmere|Beechmere]] ([[User talk:Beechmere|talk]]) 03:29, 26 September 2022 (UTC)Beechmere
 +
 +
I don't suppose a zero Julian date [January 1, 4713 BC] is very likely to appear except in astronomy data?
 +
[[Special:Contributions/172.70.174.159|172.70.174.159]] 09:08, 26 September 2022 (UTC)

Revision as of 09:08, 26 September 2022

Source for the Excel/Lotus 123 relation with Dec 30th, 1899: https://social.msdn.microsoft.com/Forums/office/en-US/f1eef5fe-ef5e-4ab6-9d92-0998d3fa6e14/what-is-story-behind-december-30-1899-as-base-date?forum=accessdev Victor (talk) 08:14, 24 September 2022 (UTC)

I feel this one. My birthday happens to be within 24 hours of 1970-01-01, so I keep getting caught off guard for a moment whenever I see my birthday showing up in one of these contexts. -- KarMann (talk) 08:35, 24 September 2022 (UTC)

We're going to need the date stamp format for 1890 ticker tape for this one. Anyone? 172.70.214.183 11:59, 24 September 2022 (UTC)

MM/DD/YY, with leading zeros omitted, and no I don't know why, but I suggest Google Books Ngrams might have a clue as to when that abomination started. 172.69.22.61 12:03, 24 September 2022 (UTC)
Not necessarily with pairs of the slash '/' _ . . _ . but also hyphens '-' _ . . . . _ and periods '.' . _ . _ . _ were used as delimiters in MM?DD?YY, which if I remember right dates to the 1500s when accounting ledgers were invented. 172.70.207.8 12:10, 24 September 2022 (UTC)
Are you with the NSA and have a data warehouse of all the ticker tapes ever sent or something? 162.158.166.185 12:45, 24 September 2022 (UTC)
No, but my great grandparents thought ticker tape parades were littering, because Great Grandma worked in an office and Great Grandpa worked for sanitation, so we have a bunch of boxes in the attic filled with what she was supposed to throw out her window. 172.71.158.75 12:54, 24 September 2022 (UTC)
That would be 1299. But I'm not sure how this is going to help us explain the comic, unless you perhaps are suggesting we enumerate date representation clusters somehow? 172.69.22.61 12:32, 24 September 2022 (UTC)
Someone should ask GPT-3 for a list of the top ten dates. 172.69.22.71 12:59, 24 September 2022 (UTC)

Just putting January 2, 2006 here: https://stackoverflow.com/questions/20530327/origin-of-mon-jan-2-150405-mst-2006-in-golang 172.69.22.161 12:28, 24 September 2022 (UTC)

Do we need a comment about how Pope Gregory XIII obliterated October 5th through 14th, 1582? 172.71.158.25 13:30, 24 September 2022 (UTC)

In Unix, January 1st, 1970 0h0 is 0. In Excel, December 31st, 1899 is 1. Either Randal forgot December has 31 days (hence December 30th) or he though Excel starts to count at 0 like Unix. For more information in the (probably) intentional bug in Excel https://www.joelonsoftware.com/2006/06/16/my-first-billg-review/ .

In Excel, January 1, 1900 is 1. However, December 30, 1899 is the "epoch" date that you should use if you want to convert a current date (anything on or after March 1, 1900) to a number by "subtracting" the current date minus the epoch date (counting the number of days since the epoch date). The reason it isn't December 31 is because of the above mentioned bug where Excel counts February 29, 1900 as a day even though it actually isn't.

I just checked it in different versions of Excel, you are right. Meanwhile LO Calc it is Dec 31th 1899... I'll try to edit the explaination to make it more universal. Asterisk (talk) 21:11, 24 September 2022 (UTC)
In Excel 2002 (XP) it actually interprets it as "1900-01-00" or "January 0, 1900", that's weird Asterisk (talk) 21:25, 24 September 2022 (UTC)

Speaking of dates, shouldn’t this one be in the category “Saturday comics”? Or was it still Friday in Hawaii when it came out? 162.158.107.246 17:57, 24 September 2022 (UTC)

While uploaded by the bot on 2022-09-24, the xkcd archive (and json data) states that this comic was published on 2022-09-23 —theusaf (talk) 18:44, 24 September 2022 (UTC)
The same thing happened on Monday. The comic didn't show up until Tuesday, but it was still dated Monday. Someone suggested that the book tour has been interfering with Randall's schedule. Barmar (talk) 21:25, 24 September 2022 (UTC)

I don't understand what the White Lotus Religion has to do with the comment in the title text. Nothing in the Wikipedia article linked mentions 1899 or December 30 in connection with that religion. --172.70.100.158 01:03, 25 September 2022 (UTC)

Yeah, I believe The White Lotus reference is a stretch, but it is possible, just based on the name "Lotus". This would have to be confirmed by Randall Munroe. On another matter; I'm sorry I don't have citations for Unix only becoming complete in mid-March. Dennis Ritchie himself wrote of it's birthing in 1969 in the 1978 paper,"The Evolution of the Unix Time-sharing System*" I'm quite sure of the Unix timestamp being a kind of "hack" used until a calendar app could be created. PS This Jan 1, 1970 problem was even in the first iPhones, which could be bricked by setting the date to Dec 31, 1969 or any date previous. Many an Apple Store had to put up with this nuisance. -- Cuvtixo (talk) 04:35, 25 September 2022 (please sign your comments with ~~~~)
For a number of reasons, I thought it best to revert your addition, rather than vastly edit it to make it generally better (had some good intent behind it, don't get me wrong). I thought maybe you might want to try again rather than be mercilessly re-edited into saying something you didn't mean. Didn't see your comment down here until after, though, or I might have put my energy into just prompting you to do the changes already. (I can't create a Talk page for you, in my IP state, or I might have buzzed you upon that instead.) 172.71.178.207 11:47, 25 September 2022 (UTC)

It is truly astonishing how many records there are of financial transactions between around 60 CE and 99 CE. We also found some 30-year mortgages created in 70 CE whose final payment was due in "00", an early Y0K bug (there was no year 0). 172.70.38.143 13:59, 25 September 2022 (UTC)

There is also indisputable evidence of a previously unrecorded major recession in the late first century, evidenced by the steady reduction in the number of records throught the 90's. 172.70.34.213 14:29, 25 September 2022 (UTC)

Related topic: a lot of Scottish Whisky distilleries were "founded" in the 1830s, although they existed (long) before that. But a change in taxation laws made it easy to become a legal distillery.

Overdue What-If (blog article) notification.

I just added a new row to (one of the pages for) What-If? articles. Seen last week, thought someone else would have noticed it. Turns out to have ready been published a couple of weeks earlier, so jumped right in anyway. And, as per instructions, notifying on the "latest comic page". Note the complete lack of thumbnails in that list, since (with apparently broken links) around the Interplanetary Cessna article. Which is yonks ago. And I can't really correct that issue, so leaving it as a project for someone else to do, as with any other listing-pages. ...but that's all administratium, on top of the basic FYI that I'm trying to convey here. 172.70.86.8 01:22, 26 September 2022 (UTC)

My first thoughts when reading this comic was that 30 Dec 1899 was the last business day of the 19th century, and that thousands (or millions) of people were selling their worldy assets, in the mistaken belief that the world would come to an end (sort of like a Y2K scare, but without the tech). Beechmere (talk) 03:29, 26 September 2022 (UTC)Beechmere

I don't suppose a zero Julian date [January 1, 4713 BC] is very likely to appear except in astronomy data? 172.70.174.159 09:08, 26 September 2022 (UTC)