4 ms·
I hope we'd all standardize on the opposite: 2017-09-25.. it sorts properly when used in file and document names :-)
by petercooper 9y ago
I hope we'd all standardize on the opposite: 2017-09-25.. it sorts properly when used in file and document names :-)
- deleted 9y ago[deleted]
- tonyedgecombe 9y agoand 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...
- kbart 9y ago
- 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 :)
- rbanffy 9y agoAnd all on UTC, please. End this timezone and daylight saving nightmare.
- dkersten 9y agoYes! If I were dictator of the universe, this would be my first (and possibly only) change. I'd also like metric time, but abolishing timezones and daylight saving would be more than good enough.
- maxxxxx 9y agoThat would be my dream too :)
- q-base 9y agoFunny, I never thought about that :) And coming from Denmark I would always have recommended the exact reverse.
- dingdingdang 9y agoHonestly, the 2017-09-25 format is the only way forward for automatic proper sorting of folder/files..etc.
- gglitch 9y agoAnd it can be extended down to arbitrary units. 2017-09-25 2017-09-25-0929 2017-09-25-09290000000000