Author Topic: PSA - ISO 8601  (Read 1125 times)

ergophobe

  • Inner Core
  • Hero Member
  • *
  • Posts: 9294
    • View Profile
PSA - ISO 8601
« on: September 26, 2018, 06:49:36 PM »
PSA: there is one correct way to write a date, as per ISO 8601*:

https://xkcd.com/1179/

2009-07-05 - great
5 Jul 2009 - great

5/7/09 or 7/5/09 - not okay people! People who write dates like 05/07/09 are killing me. That is the only format (not counting "punctuation") that leads to confusion. What month did this happen?


*actually ISO 8601 is more flexible than that. You can, for example, express 2009-07-05 as 2009-186 as well, but most people have trouble reading that ;-)

ergophobe

  • Inner Core
  • Hero Member
  • *
  • Posts: 9294
    • View Profile
Re: PSA - ISO 8601
« Reply #1 on: September 26, 2018, 06:50:03 PM »
Plus, only ISO 8601 dates and similar ones sort properly.

BoL

  • Inner Core
  • Hero Member
  • *
  • Posts: 1209
    • View Profile
Re: PSA - ISO 8601
« Reply #2 on: September 26, 2018, 09:34:14 PM »
The UK tends towards dd-mm-yyyy but as you say, for sorting and general ease of use yyyy-mm-dd seems much simpler to use.

We've all likely wasted a small chunk of time scanning through data with multiple rows, trying to figure out the lottery of how the dates are constructed

ergophobe

  • Inner Core
  • Hero Member
  • *
  • Posts: 9294
    • View Profile
Re: PSA - ISO 8601
« Reply #3 on: September 26, 2018, 09:48:38 PM »
My favorite alternative formats from the XKCD cartoon for 2013-02-07 are

((3+3)×(111+1)-1)×3/3-1/33

MMXIII-II-XXVII

10/11011/1101

2013.158904109

ergophobe

  • Inner Core
  • Hero Member
  • *
  • Posts: 9294
    • View Profile
Re: PSA - ISO 8601
« Reply #4 on: September 26, 2018, 09:49:13 PM »

Rumbas

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2106
  • Viking Wrath
    • MSN Messenger - rasmussoerensen@hotmail.com
    • AOL Instant Messenger - seorasmus
    • View Profile
Re: PSA - ISO 8601
« Reply #5 on: September 27, 2018, 12:21:26 PM »
Hahaha, getting this wrong all the time when dealing with you 'Muercans.

>2009-07-05 - great

NOOOO, which is month, which is day?!

FFS, why can't we all just do:

Day-Month-Year
Gram-Kilo-Ton
Mm-cm-m-km
0-24H (The WORST is all the US timezones..)

Brad

  • Inner Core
  • Hero Member
  • *
  • Posts: 4155
  • What, me worry?
    • View Profile
Re: PSA - ISO 8601
« Reply #6 on: September 27, 2018, 12:38:50 PM »
For clarity you can't beat - 27 September 2018.

As long as we all remember that a US gallon is smaller than an Imperial gallon we're all good.   ;D

ergophobe

  • Inner Core
  • Hero Member
  • *
  • Posts: 9294
    • View Profile
Re: PSA - ISO 8601
« Reply #7 on: September 27, 2018, 04:09:26 PM »
>2009-07-05 - great

NOOOO, which is month, which is day?!

ISO 8601 stipulates that units are in increasing specificity.

Quote
27 September 2018

Agreed actually. For filenames, ISO 8601 can't be beat because they sort correctly.

For all public facing communication, I try and try and try to get everyone in marketing to use the 27 September 2018 format and I try and try to explain that 20% of our customers do thing 03/04/18 is April 3 and 75% think it's March 4.... and 5% are like me and have no clue what day they mean.

I actually work with people who write date ranges this way: 4/7-9/10. What does that mean? It means April 7-9, 2010. It's less confusing now that we are past 2012. But still, 4/4-17/18 is almost unreadable.

But people persist in writing dates that way.

Quote
Gram-Kilo-Ton

I used to think this made sense. Rational. Organized. All that. Then Arlo Guthrie explained how bad the metric system is for poetry and song and I saw the fatal flaw.

Famous folk song rendered into metric:
"Centimeter by centimeter/gonna make this garden grow"

Famous poem rendered into metric:
"And kilometers to go before I sleep."

Famous play rendered into metric:
"The kilogram of flesh which I demand of him Is deerely bought, 'tis mine, and I will have it."

Sorry, but no. Just no. They should have picked better names ;-)
« Last Edit: September 27, 2018, 04:12:40 PM by ergophobe »