5 ms·
and there is no ambiguity, does 6/7/2017 mean 6th July or 7th June?
by tonyedgecombe 9y ago
and there is no ambiguity, does 6/7/2017 mean 6th July or 7th June?
- petercooper 9y agoYeah, I thought about that as I was writing my comment and realized that's why I always write "back to front dates" with dashes instead of slashes. I think it's probably because I always use that format in filenames and slashes feel like a very bad idea there ;-)
- ninjaoxygen 9y agoYes, it would be so great if there could be a standard for dates formatted this way. It would have to be called something awesome like ISO 8601! ;-) That is definitely also my preferred format, everything just sorts naturally then. Not so in love with the 2017-09-25T12:00 format as it does not work for filenames on my OS.
- lifthrasiir 9y agoISO 8601 supports an alternative format without separators, like 20170925T1200.
- linuxlizard 9y agoObligatory XKCD. https://xkcd.com/1179/ https://xkcd.com/1179/ ISO8601 is very nice.
- chuckwnelson 9y agoI love the tongue-in-cheek alt text.
- oneeyedpigeon 9y agoThere definitely still is ambiguity if you're unfamiliar with the format. Show someone "2017-07-06" and they still might be unsure whether that's June or July.
- mirimir 9y agoIf you have enough examples, you can see which field goes over 12. In undocumented datasets, that's the only option.
- kbart 9y agoI have never seen YYYY-DD-MM format, on the other hand, both DD/MM/YY and MM/DD/YY are equally common, that's why I always prefer YYYY-MM-DD format as it is the least ambiguous and most useful (sorting files etc., as other comments have mentioned). Feel free to prove me wrong though.
- robin_reala 9y agoHave you ever been to any of Kazakhstan, Latvia, Nepal or Turkmenistan? https://en.wikipedia.org/wiki/Calendar_date#Gregorian.2C_year-day-month_.28YDM.29 https://en.wikipedia.org/wiki/Calendar_date#Gregorian.2C_yea...
- mrmondo 9y agoYes that’s a huge problem and I’ve seen a lot of misunderstands from it.
- nsomaru 9y agoI always read that as 6th of the 7th, 2017. I like American dates for sorting though :)