1179: ISO 8601

Explain xkcd: It's 'cause you're dumb.
Jump to: navigation, search
ISO 8601
ISO 8601 was published on 06/05/88 and most recently amended on 12/01/04.
Title text: ISO 8601 was published on 06/05/88 and most recently amended on 12/01/04.

[edit] Explanation

Public service announcement: Two commonly used date formats are dd.mm.yyyy and mm/dd/yyyy (the symbols separating the values, as well as the year being 2 or 4 digits notwithstanding). These differences are often causes for debate. However, the comic explains that the International Organization for Standardization (ISO) has standardized dates in the yyyy-mm-dd format, in its ISO 8601 standard.

The comic then lists many formats as "discouraged". This list starts with commonly used formats, which include the two above as well as other commonly used ones, such as dd/mm/yy. However the list then starts listing formats ranging from uncommon to absurd, such as writing the date partly in Roman numerals and painting the date in m-d-yy format with white paint onto a hissing black cat.

The ISO standard was published (to use yet another date format) on 5 June 1988 and amended on 1 December 2004, two dates given in the title text in mm/dd/yy format. Since the day values are less than 13, the format used demonstrates its ambiguity; it could be interpreted as other dates given in dd/mm/yy format (the first also as 6 May; the last as no less than five other dates as well. In both cases the century is not determined). The dates are clearly not written in ISO 8601 format, contradicting the advice in this comic, adding a level of metahumor.

Date formats was again the subject in 1340: Unique Date.

The other mentioned formats are:

Date Explanation
02/27/2013 MM/DD/YYYY, used mostly in the US.
02/27/13 MM/DD/YY
27/02/2013 DD/MM/YYYY, used e.g. in South America, Canada (officially uses ISO 8601), Australia, New Zealand and Europe.
27/02/13 DD/MM/YY
20130227 YYYYMMDD, also allowed in ISO 8601
2013.02.27 YYYY.MM.DD, used in Japan
27.02.13 DD.MM.YY, used e.g. in Germany, Russia
27-02-13 DD-MM-YY, used in Denmark, Netherlands, Indonesia, India, Bangladesh, etc.
27.2.13 D.M.YY
2013. II. 27. YYYY. MM. DD., with month as Roman numerals, used in Hungary.
272-13 DM-YY, traditional format in Sweden
2013.158904109 Year and decimal fraction of year – 58/365, February 27 being the 58th day of the year. This representation marks the end of that day. Also allowed in ISO 8601. It is not rounded correctly 58/365 = 2013.1589041096.
MMXIII-II-XXVII Year-month-day in Roman numerals
MMXIII [and] LVII [over] CCCLXV Year and 57/365. This representation marks the start of the day, which is 57 days after the year started.
1330300800 UNIX Timestamp, but for 2012-02-27. This refers to geohashing done by Randall at this date.
((3+3)×(111+1)-1)×3/3-1/33 Year/month/day with the parts written as arithmetic expressions, using just the digits 1 and 3. (The slashes are not to be interpreted as fraction lines.)
27 [on] 02 [on] 2013 An obfuscated date format not used ordinarily. This can be considered a compromise between the different formats: since we cannot agree on which position in the date the day, month and year parts shall be, we just write them all in the same place; we don't even need separators, which we cannot agree on either. On the other hand, reading it gets somewhat tricky...
10/11011/1101 Month/day/year in binary = 2/27/13.
02/27/20/13 Month/Day/Century (counting from 0 and not from 1)/Year.
0 [2,5] 1 [3] 2 [1,6,7] 3 [4] 7 [8] The large digits are to be placed at the positions listed above and below: 0 is used at positions 2 and 5, 1 is used on position 3, etc.; the result being 20130227
A cat with "2-27-13" painted on it, going HiSSSS In Western cultures, black cats and the number 13 are associated with bad luck. The cat might also just be angry that someone painted an unstandardized date on it. The cat's "Hissss" could be a reference to timestamp formats in PHP web programming, where the desired date format is generally followed by "H:i:s", the standard 24-hour time format. That would explain the specifically lowercase "i" in the cat's hiss. It could also be a reference to LOLcats as in 262: IN UR REALITY.

[edit] Transcript

Public Service Announcement:
Our different ways of writing dates as numbers can lead to online confusion. That's why in 1988 ISO set a global standard numeric date format. This is the correct way to write numeric dates:
2013-02-27
The following formats are therefore discouraged:
  • 02/27/2013
  • 02/27/13
  • 27/02/2013
  • 27/02/13
  • 20130227
  • 2013.02.27
  • 27.02.13
  • 27-02-13
  • 27.2.13
  • 2013. II. 27.
  • 272-13
  • 2013.158904109
  • MMXIII-II-XXVII
  • MMXIII [and] LVII [over] CCCLXV
  • 1330300800 [This is the UNIX time for 2012-02-27, Randall.]
  • ((3+3)×(111+1)-1)×3/3-1/33 [the numbers 2013, 02, and 27 written overlapping each other]
  • 10/11011/1101
  • 02/27/20/13
  • [A black, hissing cat with 2-27-13 written on it.]
  • [The following is the last entry] 2 3 1 4 0 1 2 3 7 5 67 8
comment.png add a comment!

Discussion

Apparently there are some mistakes in the Roman numerals in the comic, the year MMXII is 2012. Also LVII/CCLXV = 57/265, whereas February 27th is the 58th day of the year (which has 365 days). --ulm (talk) 07:55, 27 February 2013 (UTC)

Just guessing, but could this have something to do with the divergence of various Roman calendars, e.g. Julian vs. Gregorian? 98.122.166.235 13:55, 27 February 2013 (UTC)
Another error: Obviously 1330300800 is intended to be Unix time, but it corresponds to 2012-02-27 00:00:00 UTC. --ulm (talk) 08:10, 27 February 2013 (UTC)
The day part "57" is not wrong: Since Feb 27 is the 58th day of the year, at the beginning of that day, 57 days have gone by since the year started. (At the end of the day, 58 days have gone by) Since we associate days with their beginning (like we do with e.g. hours and minutes), 57 is the correct number (or else Dec 31 would be 2013+365/365 = 2014, and therefore in the wrong year) -- Xorg (talk) 13:53, 27 February 2013 (UTC)
The day part is ambiguous. It could be as Xorg suggests, the fraction of the year past at the start of the day. On the other hand it could be interpreted as "day 57 or 365," as with pieces in a shipment or page numbers. In the latter case it should be 58/265. But then, that (ambiguity) is the point, isn't it? Jqavins (talk) 17:40, 27 February 2013 (UTC)
Meanwhile the comic was replaced, with CCLXV corrected to CCCLXV. --ulm (talk) Prima vigilia, XVI Kal. Mar. MMDCCLXVI
I was just about to publish my theory of how "2012" in the Roman numerals in just the same vein might be intended to indeed represent the year we denote "2013", but by counting only the finished years. This would also connect with the confusion over year zero, another thing that ISO 8601 tried to straighten out. (They placed it before year 1.) Everything fit so well. Then there was an edit conflict, following Randalls correction to "2013". I guess you can't always be right. –St.nerol (talk) 23:03, 27 February 2013 (UTC)

Can anyone explain 01237 (last interpretation before the cat)? Thanks 68.230.38.154 08:04, 27 February 2013 (UTC)

The small numbers above and below the larger ones show which digit is used where. For example, the 2nd and 5th digit is a 0, the 3rd digit is a 1 etc. 82.115.151.1 08:15, 27 February 2013 (UTC)
01237 are the digits used in the date, and the numbers above and below them reflect the order in which they are written; 0 is the second and fifth digit, 1 is the third digit, 2 is the first, sixth and seventh digit, 3 is the fourth digit, and 7 is the eighth digit: 20130227 Bdemirci (talk) 08:15, 27 February 2013 (UTC)

Someone can explain me what means: ((3+3)×(111+1)-1)×3/3-1/33? 95.23.147.48 (talk) (please sign your comments with ~~~~)

Read the comic explanation. Davidy²²[talk] 10:58, 27 February 2013 (UTC)

Many of these format mirror how the dates are spoken in languages. For example, Americans will say "February 27, 2013" and write "2/27/2013", whereas the French will say "27 février 2013" and write "27-02-2013". As a scientist, I was encouraged to write "27 II 2013" (which is apparently standard in Hungary, according to the explanation above) in my lab notebook to avoid ambiguity. --Prooffreader (talk) 13:16, 28 February 2013 (UTC)

A strange thing is that he forgot the form mostly used in Europe: 27.01.2013. --DaB. (talk) 12:44, 27 February 2013 (UTC)

That form is mostly used in Germany. Belgium and France use 27/01/2013 more, Netherlands use 27-01-2013. No idea what the UK prefers although I could imagine 01.27.2013.62.159.14.62 12:58, 27 February 2013 (UTC)
The UK prefers 27/02/2013 --H (talk) 13:20, 27 February 2013 (UTC)
That form (27.02.2013) is also common in all of Scandinavia. --Buggz (talk) 14:15, 27 February 2013 (UTC)

The image text has a subtle twist as "12/01/04" offers no contextual clues to it meaning at all, can be read three different ways : "December 1st 2004", "January 12, 2004" or "January 4th, 2012" (as opposed to, for example, "01/15/98" which could only be interrupted as "January 15th, 1998") JamesCurran (talk) 14:29, 27 February 2013 (UTC)

Technically speaking, it could also be interpreted as April 1st 2012 or April 12th 2001, though that would be the least likely interpretation. I personally like spelling out 3 letters of the month and using an apostrophe before the year, such as 27 Feb '13. --Joehammer79 (talk) 15:07, 27 February 2013 (UTC)
And of course December, 4th 2001 Sebastian --178.26.118.249 19:54, 27 February 2013 (UTC)

Is there any way to convert the time-stamp placed on these comments to the YYYY-MM-DD format? --16:17, 27 February 2013 (UTC)

If you're logged in, you can set your date and time preferences. I doubt it will affect the timestamps on this page, though, since those appear to be saved as plain text. --Aaron of Mpls (talk) 23:01, 27 February 2013 (UTC)

I feel like the cat thing is a reference to something, but I'm not sure what... is it something? A quick google image search pulls up nothing. --Jeff (talk) 17:26, 27 February 2013 (UTC)

Seems to me that Randall missed an opportunity: Why a cat? Why not a bobcat? It still could be some other reference that I'm missing too.
Black cats are considered unlucky. I don't see any reference beyond that. Mattflaschen (talk) 17:59, 27 February 2013 (UTC)
It's taking the last two digits from 2013 and emphasizing triskaidekaphobia. Doing a web image search on "Cat 13" will pull up similar artwork of hissing black cats combined with the number 13, including both flyers for Friday 13th drink specials at bars, and combat airplane noseart. Apparently combining the unlucky "13" with an unlucky black cat emphasized that they were bad luck for the enemy. Columbus Admission (talk) 19:20, 27 February 2013 (UTC)
"You're a Kitty!" http://www.explainxkcd.com/wiki/index.php?title=231
The cat's "Hissss" could be a reference to timestamp formats in PHP web programming, where the desired date format is generally followed by "H:i:s", the standard 24-hour time format. That would explain the specifically lowercase "i" in the cat's hiss.208.87.234.180 13:28, 22 March 2013 (UTC)

Cool, this is my birthday. Mattflaschen (talk) 17:59, 27 February 2013 (UTC)

"However the list then starts listing formats ranging from uncommon to absurd, such as writing the date partly in Roman numerals [...] " - My math teacher uses a very similar format (in reverse order, d/m/yy, with m being in Roman numerals, because this is Germany (see above)), so I wouldn't call it absurd. She is the only person I know who uses it though. 87.189.150.212 19:36, 27 February 2013 (UTC)

The image and explanation needs to be updated for the corrections. I could do the explanation part, but I have no idea how to do the image part. And one without the other would be confusing for the readers, so I'll leave that to wiki-magic. 76.106.251.87 21:09, 27 February 2013 (UTC)

I updated the image as well as the explanation (and transcript). There is still the error on the Unix timestamp though (will this comic be fixed a third time?...). - Cos (talk) 21:57, 27 February 2013 (UTC)

Sweden uses the ISO 8601 format. (If only food producers could understand this as well..) 46.59.16.141 21:42, 27 February 2013 (UTC)

- What can we learn from this? - I've learned that no matter the system we use today to communicate with others, it's probably seems silly for someone else. It's great to document what we do and propose it as an option to others, but it will be next to impossible to force them to adopt. When someone will develop a time reference that makes sense to everyone, it will be adopted all over the world without much effort. - e-inspired 24.51.197.187 19:07, 27 February 2013 (UTC)

Perhaps the cat (because of the vagueness of the system) was referring to not the 27th of February 2013. but instead referring to the 13th of February in 1327 which would make it Friday the 13th. 66.35.1.98 (talk) (please sign your comments with ~~~~)

Just so you know, Explainxkcd wiki uses the ISO certified date standard for its "All Comics" page. Davidy²²[talk] 01:57, 28 February 2013 (UTC)

Personally I've always preferred to use Year-Month-Day my personal stuff. I like it because the format is written the way we write any other number: Most significant to left, least significant to right. I didn't know this was a standardized method and I've always wondered why it wasn't used. Nice to know it is!172.191.224.64 04:09, 28 February 2013 (UTC)ExternalMonologue

Personally, I like yyyy-mm-dd because it sorts correctly. I really hate running into a list of dates sorted by month name, or worse, day of the week. I suspect this was part of why ISO chose this format. I've never been able to remember the american vs european ordering... My only other options is: February 27, 2013. Divad27182 (talk) 12:11, 28 February 2013 (UTC)

I'm not sure what standard the Canadian Military officially uses, but as soldiers we were all taught to use a "7 Feb 2013" format when writing dates. Seems the most clear and concise to me. 24.85.225.143 (talk) (please sign your comments with ~~~~)
Most of the dates I've seen used by the Canadian Military have been of that format but have only used 2-digit years - e.g. 27 Feb 13 (they didn't learn from Y2K!) 64.140.113.219 (talk) (please sign your comments with ~~~~)

- What can we learn from this? - I've learned that keeping our time relative to earth rotation is outdated, we keep having to add seconds here and there just to keep time. And as an engineer don't get me started on complexity of mktime function. I personally think of time as oscillation of a flawed crystal in my circuits that I constantly need to keep accounting for through endless calibrations, and keep wishing that better time references would be cheaper (to me good is never good enough) - E-inspired (talk) 15:05, 28 February 2013 (UTC)

Ha ha E-inspired you should read the "falsehoods programmers believe about times" http://infiniteundo.com/post/25326999628/falsehoods-programmers-believe-about-time http://infiniteundo.com/post/25509354022/more-falsehoods-programmers-believe-about-time-wisdom 75.103.23.206 20:14, 28 February 2013 (UTC)

Dude, you've just made my DAY! I forgot the last time I've laughed as hard. Why didn't I know about this site before? - E-inspired (talk) 20:43, 28 February 2013 (UTC)
Why is the date of this comic written as "February 27, 2013" and not "2013-02-27"? 93.73.186.104 08:46, 14 March 2013 (UTC)
Personal tools
Namespaces

Variants
Actions
Navigation
Tools

It seems you are using noscript, which is stopping our project wonderful ads from working. Explain xkcd uses ads to pay for bandwidth, and we manually approve all our advertisers, and our ads are restricted to unobtrusive images and slow animated GIFs. If you found this site helpful, please consider whitelisting us.

Want to advertise with us, or donate to us with Paypal or Bitcoin?