Editing 1179: ISO 8601

Jump to: navigation, search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision Your text
Line 8: Line 8:
  
 
==Explanation==
 
==Explanation==
When abbreviating the date into numerical form, {{w|Date format by country|various areas of the world}} tend to list the year, month, and day in different orders (as well as with different delimiting symbols), which can cause confusion particularly when the day value is 12 or lower allowing it to be easily interpreted as the month and vice versa. As a {{w|public service announcement}}, this comic states that there is in fact one international standard for writing numeric dates, set by the {{w|International Organization for Standardization}} in its {{w|ISO 8601}} standard: YYYY-MM-DD.
+
When abbreviating the date into numerical form, {{w|Date format by country|various areas of the world}} tend to list the year, month, and day in different orders (as well as with different delimiting symbols), which can cause confusion particularly when the day value is 12 or lower allowing it to be easily interpreted as the month and vice versa. As a {{w|public service announcement}}, this comic states that there is in fact one international standard for writing numeric dates, set by the {{w|International Organization for Standardization}} in its {{w|ISO 8601}} standard.
  
The comic then proceeds to list several discouraged ways of writing out the date of the comic's publication, as they do not match the standard. It begins with several commonly used ones in countries around the world but then begins to list increasingly uncommon ways, ranging from strange (Roman numerals) to quirky (binary, Unix time) to essentially impossible (painting the numbers onto a black cat).
+
The comic then proceeds to list several discouraged ways of writing out the date of the comic's publication, as they do not match the standard. It begins with several commonly used ones in countries around the world, but then begins to list increasingly uncommon ways, ranging from strange (Roman numerals) to quirky (binary, Unix time) to essentially impossible (painting the numbers onto a black cat).
  
The title text provides a perfect example of the kind of ambiguity that can arise when non-standard formats are used. The ISO standard was in fact published on 1988-06-05 and amended on 2004-12-01. This is mentioned in the title text in MM/DD/YY format; however, there is no way to naturally figure this out, particularly with the second date.
+
The title text provides a perfect example of the kind of ambiguity that can arise when non-standard formats are used. The ISO standard was in fact published on 1988-06-05 and amended on 2004-12-01. This is mentioned in the title text in mm/dd/yy format; however, there is no way to naturally figure this out, particularly with the second date. With the year truncated to two digits and all three numbers at 12 or lower, the date referring to December 1, 2004 may well be interpreted as 12 January 2004, or as 2012-01-04.
  
With the year truncated to two digits and all three numbers at 12 or lower, the date referring to December 1, 2004 (the digits pairs 12, 01 and 04) has a number of misinterpretations. Usually 12<sup>th</sup> Jan '04 (if written as US-style but read as European, or vice-versa) but with ISO-influenced "YY MM DD" ordering as one side or other of the misunderstanding it can easily become the 12<sup>th</sup> day of April 2001, the 4<sup>th</sup> day of December 2001 and the 4<sup>th</sup> of January 2012. It takes two such communication errors to 'become' the 1<sup>st</sup> day of April 2012.
+
Date formats was again the subject in [[1340: Unique Date]].
 
 
Date formats were again the subject in [[1340: Unique Date]] and [[2562: Formatting Meeting]].
 
  
 
The other mentioned formats are:
 
The other mentioned formats are:
Line 24: Line 22:
 
|-
 
|-
 
| 02/27/2013
 
| 02/27/2013
| MM/DD/YYYY, used mostly in the [https://www.trustedtranslations.com/blog/how-are-dates-written-in-different-countries United States, Belize and Micronesia].
+
| MM/DD/YYYY, used mostly in the United States.
 
|-
 
|-
 
| 02/27/13
 
| 02/27/13
Line 30: Line 28:
 
|-
 
|-
 
| 27/02/2013
 
| 27/02/2013
| DD/MM/YYYY, used variously in South America, Canada ({{w|Date_and_time_notation_in_Canada|officially uses ISO 8601}}), Australia, New Zealand and much of Europe.
+
| DD/MM/YYYY, used variously in South America, Canada ({{w|Date_and_time_notation_in_Canada|officially uses ISO 8601}}), Australia, New Zealand and Europe.
 
|-
 
|-
 
| 27/02/13
 
| 27/02/13
Line 39: Line 37:
 
|-
 
|-
 
| 2013.02.27
 
| 2013.02.27
| YYYY.MM.DD, used in Japan, South Korea and Hungary. Same as ISO 8601 except with different punctuation.
+
| YYYY.MM.DD, used in Japan. Same as ISO 8601 except with different punctuation.
 
|-
 
|-
 
| 27.02.13
 
| 27.02.13
Line 51: Line 49:
 
|-
 
|-
 
| 2013. II. 27.
 
| 2013. II. 27.
| YYYY. MM. DD., with month as {{w|Roman numerals}}, used in Hungary. In this format, February and November are prone to be confused with each other: "II" vs. "11".<br/>Similar formats with the opposite ordering (27. II. 2013) existed historically in various European countries like France, Germany and Italy.  
+
| YYYY. MM. DD., with month as {{w|Roman numerals}}, used in Hungary.
 
|-
 
|-
 
| <sup>27</sup>⁄<sub>2</sub>-13
 
| <sup>27</sup>⁄<sub>2</sub>-13
| <sup>D</sup>⁄<sub>M</sub>-YY, traditional format in Denmark, Norway and Sweden
+
| <sup>D</sup>⁄<sub>M</sub>-YY, traditional format in Sweden
 
|-
 
|-
 
| 2013.158904109
 
| 2013.158904109
| Year and decimal fraction of year. 0.158904109 is a decimal approximation of 58/365, with February 27 being the 58th day of the year. This format may be easier to read for computers/programs in some contexts, but is difficult for humans to interpret.
+
| Year and decimal fraction of year. 0.158904109 is a decimal approximation of 58/365, with February 27 being the 58th day of the year. Allowed in ISO 8601 as it is not ambiguous; presumably easier to read for computers/programs but difficult for humans.
 
|-
 
|-
 
| MMXIII-II-XXVII
 
| MMXIII-II-XXVII
Line 66: Line 64:
 
|-
 
|-
 
| 1330300800
 
| 1330300800
| {{w|Unix time|UNIX Timestamp}}, a standard method of storing absolute time in many computer systems and defined as the number of seconds since 00:00:00 on 1970-01-01 (UTC). The Unix time listed here appears to mistakenly be for '''2012'''-02-27, which is also mentioned by [[Randall]] in the original transcript. The Unix Timestamp for 2013-02-27 would be 1361923200.
+
| {{w|Unix time|UNIX Timestamp}}, a standard method of storing absolute time in many computer systems and defined as the number of seconds since 00:00:00 on 1970-01-01 (UTC). The Unix time listed here appears to mistakenly be for '''2012'''-02-27, which is also mentioned by [[Randall]] in the original transcript.
 
|-
 
|-
 
| ((3+3)×(111+1)-1)×3/3-1/3<sup>3</sup>
 
| ((3+3)×(111+1)-1)×3/3-1/3<sup>3</sup>
| A useless format where the numbers 2013, 2, and 27 written as needlessly long arithmetic expressions using just the digits 1 and 3. For additional confusion, the values are delimited by slashes, enabling confusion with the fraction bar.  (If evaluated literally, the entire expression evaluates to 670.963, or 671 minus one twenty-seventh.)
+
| A useless format where the numbers 2013, 2, and 27 written as needlessly long arithmetic expressions using just the digits 1 and 3. For additional confusion, the values are delimited by slashes, enabling confusion with the fraction bar.  (If evaluated literally, the entire expression evaluates to 670.963, or 671 minus 1 divided by 27.)
 
|-
 
|-
 
| <span style="position:absolute;">&nbsp;&nbsp;&nbsp;2</span><span style="position:absolute;">&nbsp;&nbsp;27</span>2013
 
| <span style="position:absolute;">&nbsp;&nbsp;&nbsp;2</span><span style="position:absolute;">&nbsp;&nbsp;27</span>2013
Line 78: Line 76:
 
|-
 
|-
 
| 02/27/20/13
 
| 02/27/20/13
| MM/DD/CC/YY, where CC stands for century. This format is never used.{{Citation needed}} Note that while months and days count starting from 1, centuries and years in this format count from 0 for extra confusion. But the CC value is widely used on many operating systems to distinguish between the 20th and 21st century, represented by the values "19" and "20" because 1950 belongs to the 20th century.
+
| MM/DD/CC/YY, where CC stands for century. This format is never used. Note that while months and days count starting from 1, centuries and years in this format count from 0 for extra confusion. But the CC value is widely used on many operating systems to distinguish between the 20th and 21st century, represented by the values "19" and "20" because 1950 belongs to the 20th century.
 
|-
 
|-
| <table style="display: inline-table; line-height: 0.6em; align: middle; text-size-adjust: none;"><tr style="font-size:7pt; text-align: center"><td>2</td><td>3</td><td>1</td><td>4</td><td></td></tr><tr style="text-align: center"><td>0</td><td>1</td><td>2</td><td>3</td><td>7</td></tr><tr style="font-size:7pt; text-align: center"><td>5</td><td></td><td>67</td><td></td><td>8</td></tr></table>
+
| <sup><sup>2</sup></sup>0<sub><sub>5</sub></sub><sup><sup>3</sup></sup>1<sup><sup>1</sup></sup>2<sub><sub>67</sub></sub><sup><sup>4</sup></sup>37<sub><sub>8</sub></sub>
| An obfuscated format where the small numbers indicate the positions where the respective large digits should be placed. In this reading, 0 is used at positions 2 and 5, 1 is used on position 3, etc. Coincidentally or not, positions 1 to 4 (the year) being all placed above their digits and 5 to 8 (month and day) below; the result being 20130227
+
| An obfuscated format where the small numbers indicate the positions where the large digits should be placed. In this reading, 0 is used at positions 2 and 5, 1 is used on position 3, etc.; the result being 20130227
 
|-
 
|-
 
| [A hissing black cat with "2-27-13" painted on it]
 
| [A hissing black cat with "2-27-13" painted on it]
Line 109: Line 107:
 
:*MMXIII-II-XXVII
 
:*MMXIII-II-XXVII
 
:*MMXIII <sup>LVII</sup>⁄<sub>CCCLXV</sub>
 
:*MMXIII <sup>LVII</sup>⁄<sub>CCCLXV</sub>
:*1330300800
+
:*1330300800 [This is the UNIX time for *2012*-02-27, Randall.]
 
:*((3+3)×(111+1)-1)×3/3-1/3<sup>3</sup>
 
:*((3+3)×(111+1)-1)×3/3-1/3<sup>3</sup>
 
:*<span style="position:absolute;">&nbsp;&nbsp;&nbsp;2</span><span style="position:absolute;">&nbsp;&nbsp;27</span>2013 [the numbers 2013, 02, and 27 written overlapping each other]
 
:*<span style="position:absolute;">&nbsp;&nbsp;&nbsp;2</span><span style="position:absolute;">&nbsp;&nbsp;27</span>2013 [the numbers 2013, 02, and 27 written overlapping each other]
Line 120: Line 118:
 
{{comic discussion}}
 
{{comic discussion}}
 
[[Category:Math]]
 
[[Category:Math]]
[[Category:Calendar]]
 
[[Category:Binary]]
 

Please note that all contributions to explain xkcd may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see explain xkcd:Copyrights for details). Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:

Cancel | Editing help (opens in new window)