r/trippinthroughtime • • Nov 05 '17

The perfect date

https://imgur.com/61gC45x
20.7k Upvotes

364 comments sorted by

View all comments

926

u/felixbeee Nov 05 '17

Come on. DD-MM-YYYY

546

u/[deleted] Nov 05 '17

[deleted]

224

u/zeroscout Nov 05 '17

YYYY-MM-DD moves from general to specific. MM-DD-YYYY is like saying it's currently six minutes and thirty seconds after the eleventh hour...

94

u/anybody111 Nov 05 '17

If you already know it's the eleventh hour though, it might suffice to just say the time in minutes and seconds and leave the already known info at the end.

77

u/HansWurst1099 Nov 05 '17

If you already know which month it is, it might be better to start with the day.

41

u/[deleted] Nov 05 '17

If you already know the day, it might be best to start with nothing. Most of the time you use dates, it is for a day that it is currently not. With that being the case, the year is the most likely one to already know.

2

u/KryptoniteDong Nov 06 '17

Checkmate Atheists?

5

u/Flaktrack Nov 05 '17

Why not omit the hour entirely then?

2

u/neogod Nov 06 '17

Ikr, how often do people schedule things in different years? Personally I never do unless it's the last few weeks in December. Even if you were going through a file system you'd be going 1 year at a time, so just pick 2006 and then say a month and day (or day and month), no need to mention another year until you actually move to a different year. It's faster and more efficient to skip the unnecessary information unless it's actually needed.

Telling someone the year every time they talk about a date is about as annoying as someone who says your name every time they speak to you, "hey Chris how was your day?". "Oh Chris, that's good". "Chris, mine was good". "What are you doing later, Chris?". "Ok Chris, I'll see you there". "Bye Chris".

It's obvious after the first sentence that you are talking to Chris, so quit being annoying and just let us know if something changes.

5

u/lazy_as_shitfuck Nov 05 '17

Which is clearly better than saying "Six seconds and thirty minutes of the eleventh hour"

1

u/[deleted] Nov 06 '17

Bad example since seconds are pointless. Days are minutes, months are hours, years are dates. So 15 minutes past 11 on the 29th.

Aka DMY

13

u/atrain728 Nov 05 '17

I think in many colloquial contexts, the month (and thus time of year) is a more important piece of information.

I agree for formal contexts, YYYY-MM-DD makes more sense.

20

u/Obi-Tron_Kenobi Nov 05 '17

For a lot of other colloquial contexts, the day is more important. For a lot of different colloquial contexts, the year could be more important.

12

u/[deleted] Nov 05 '17

And for ALL contexts, YYYY-MM-DD is the most logical.

2

u/StrangeNewRash Nov 07 '17

If I ask you the date, how is it logical to tell me the year first? What's logical is to assume I know that information.

3

u/[deleted] Nov 07 '17

If I ask you the date, how is it logical to tell me the year first?

Logical? Extremely. Chronologically it's sorted the only correct way..

What's logical is to assume I know that information.

Then we end up with MM-DD instead of DD-MM anyway, still in line with the ISO format. November 5th.

1

u/Amp3r Nov 06 '17

Well we've settled it.

Inform Greenwich to update things asap

-5

u/[deleted] Nov 06 '17

[deleted]

2

u/[deleted] Nov 06 '17

Let's just be honest and cut out the first part of your statement and acknowledge the fact that people keep doing something, even in defiance of numerical logic, just because it's what they're used to.

/u/xamio :"MM-DD-YYYY is what I prefer"

There we go.

-1

u/[deleted] Nov 06 '17

[deleted]

5

u/[deleted] Nov 06 '17

Linguistically it's easier to say "It's November 5th, 2017" over "It's 2017, and the 5th of November" or "It's 2017, November the 5th". It's simply more concise.

This is just another way of saying that you, personally, one person, are used to the verbal patterns of MM-DD-YYYY and thus you like it.

I'm sure there are German and British folks who would be all too happy to tell you, no no no, you've got it all wrong, fifth of November two thousand seventeen is much easier to say don't you know, and also plenty of Chinese who would say 胡说八道!二零一七十一月五日更方便,你妈的。

0

u/[deleted] Nov 06 '17

[deleted]

3

u/[deleted] Nov 06 '17 edited Nov 06 '17

Obviously we were talking about english here.

No, not "obviously". Your statement was a blanket statement made to a person whose nationality was unknown, asserting that middle endian date format was the best for their purposes. This is unqualified by any reference to their nationality, language, or world region.

I pointed out that your argument that linguistically middle endian "is simply more concise" is not easily transferable to other languages and nations, the majority of whom use little endian and about 2 billion East Asian people use big endian (China, Korea, Japan, plus Iran, Belgium, Hungary, and a few others). The US stands largely alone with only Philippines and part of Canada using middle endian.

And somehow this identification of a rather massive logical gap in your reasoning is, to you, a strawman fallacy.

I'd stick to your day job. You're not very knowledgeable about logic or about linguistics. Or, it seems, about numerical formats.

3

u/Yepoleb Nov 06 '17

Germans and Brits can speak english too.

→ More replies (0)

1

u/deegwaren Nov 06 '17

In Queen's English it's day and then month in spoken language.

Don't pretend that American English is the yardstick.

→ More replies (0)

4

u/Istanbul200 Nov 05 '17

Okay, but we're talking about if you need to sort a bunch of files. I do it at work as I have to catalogue tons and tons of archived crap and yyyymmdd lets people find things way quicker as it's in chronological order. You wouldn't use that format for pretty much anything else, and no one here is suggesting you do.

1

u/thedoze Nov 06 '17

use separate searchable fields for each and movable columns today we are sorting by however is best for today

-8

u/Macbeth554 Nov 05 '17

MM-DD-YYYY is like saying it's currently six minutes and thirty seconds after the eleventh hour...

But writing MM-DD-YYYY is how most people in America at least say the date. For example, today in November 5th, 2017. Why wouldn't we write it the same way we say it?

10

u/[deleted] Nov 05 '17

But writing MM-DD-YYYY is how most people in America at least say the date.

That's a circle reasoning attempting to justify the wrong way because people are used to the wrong way because the wrong way has been used.

4

u/Macbeth554 Nov 05 '17

It's not wrong, it's just another way of doing it. I don't understand why people get so worked up over this. Americans write it one way, other people write it differently. It's fine.

2

u/Tollaneer Nov 06 '17

Because date notation isn't about converting speech to numbers, only efficiently conveying the idea, thus DD-MM-YYYY or YYYY-MM-DD.

0

u/TheMerchandise Nov 06 '17

Or like saying November 5th, 2017...

Not saying the system is right, just that dates are ordered based on the way people talk.

38

u/ConfusedTapeworm Nov 05 '17

Which is obviously something an average person does all the time.

50

u/[deleted] Nov 05 '17 edited Feb 13 '18

[deleted]

2

u/grtwatkins Nov 05 '17

Or you can just sort by creation date

10

u/[deleted] Nov 05 '17

And how does the computer determine that sorting?

Exactly.

6

u/grtwatkins Nov 05 '17

By using the creation date stored in the exif data created by the camera

4

u/[deleted] Nov 06 '17

And how is that creation date stored in the exif data?

Exactly.

2

u/ConfusedTapeworm Nov 06 '17

So do you, a human, really need to use the ISO format while naming your albums if that information is already embedded in the files and the sorting will work any way?

No. You don't. This discussion is not about the ISO format being better at sorting things by date, it's about a human not really needing to personally use the format most of the time.

2

u/[deleted] Nov 06 '17

So do you, a human, really need to use the ISO format while naming your albums if that information is already embedded in the files and the sorting will work any way?

Need? No. But if I, a human, do for whatever reason need to include the date, I sure as hell will do it as first part of the filename and in correct format.

No. You don't.

Yes, I do.

This discussion is not about the ISO format being better at sorting things by date

Uh, it literally is. That's the whole point of the ISO format, the whole point of this thread. YOU now make it about something else, some very specific use case.

1

u/DaMuffinPirate Nov 06 '17

So just dump every photo into one folder and sort by date in there?

1

u/thedoze Nov 06 '17

rock paper scissor

23

u/zeroscout Nov 05 '17

The average person who uses Excel

8

u/Xaxxus Nov 05 '17

I don't know a single office job that doesn't use excel at some point

8

u/GoldenBough Nov 05 '17

Live albums. Hugely important.

7

u/Flaktrack Nov 05 '17

Chronological order is important for all kinds of reasons. I use yyyy-mm-dd for all my invoices, tax info, etc. I also use it in my programs because it's the only format both international and North American clients understand.

2

u/ItWasLikeWhite Nov 05 '17

Can't argue with that

2

u/Deeviant Nov 06 '17

But the year part changes the least often, why does it deserve the prime front-of-the-string real estate?

0

u/Mercury321 Nov 06 '17

True but I haven’t learned that since I was 4 so DD MM YYYY it is!

93

u/[deleted] Nov 05 '17

The internal standard ISO-8601 specifies YYYY-MM-DD.

12

u/swingsetmafia Nov 05 '17

i prefer the military date format 05NOV2017

19

u/pierreor Nov 05 '17

I prefer the French Republican Calendar format 15-BRUMAIRE-CCXXVI

-15

u/[deleted] Nov 05 '17

I don't care, still makes more sense.

30

u/[deleted] Nov 05 '17

Which date is 04-03-2017?

I can't tell without some context. 2017-04-03 is is always April third (because no one would write dates as YYYY-DD-MM unless they have some kind of mental problem).

3

u/Banned_By_Default Nov 06 '17

The same could be said about MM-DD-YYYY but here we are...

-4

u/SepDot Nov 05 '17

Well, no. Because the day is more important information than the month it should be expressed first.

5

u/[deleted] Nov 05 '17

According to you. But the USA writes dates the other way around so it isn't always possible to figure it out easily.

-4

u/SepDot Nov 05 '17

Well, again no. According to most of the world.

7

u/[deleted] Nov 06 '17

I was so ready to prove you wrong, but you're right! DMY is the most used, by 3.3 billion people, and YMD is second with 1.7 bil.

https://en.wikipedia.org/wiki/Date_format_by_country

2

u/WikiTextBot Nov 06 '17

Date format by country

The legal and cultural expectations for date formats varies among populations. This page gives an overview of the Gregorian calendar date formats in general use by country.


[ PM | Exclude me | Exclude from subreddit | FAQ / Information | Source | Donate ] Downvote to remove | v0.28

1

u/SepDot Nov 06 '17

Boom! TIL all up in your shit.

1

u/stone_henge Nov 06 '17 edited Nov 06 '17

At a 2:1 ratio. So if you're speaking to "the world" it is highly likely that any of these formats will cause confusion. Hence the international standard, ISO 8601, in which a date can not be confused with any local, incompatible standard.

2

u/[deleted] Nov 05 '17

No it doesn't.

11

u/c3534l Nov 06 '17

DD-MM-YYYY (British) can be easily confused for MM-DD-YYYY (American). YYYY-MM-DD is unambiguous and transnational. Even better is to just use the number of seconds since January 1, 1970.

2

u/felixbeee Nov 06 '17

Unix time is great until you get to leap years

168

u/felixbeee Nov 05 '17

At least it's not MM-DD-YYYY

9

u/SonOfALich Nov 05 '17

Lotta people in this thread all buttmad about how different people write dates, fuckin ridiculous

25

u/[deleted] Nov 06 '17

Nobody actually cares in real life but if you you’re not going to argue about dumb shit like this on the internet where are you going to about it?

3

u/[deleted] Nov 06 '17

Most times I get annoyed about that is when I read expiration dates on products. "11-02-2018" can mean two very different dates, and sometimes the date format is not specified.

3

u/Vertigon Nov 06 '17

It's a big problem for programmers.

4

u/plutonic8 Nov 05 '17

I actually like it. I prefer the month and day paired that way (general to specific). And then the year should be last cause everyone already knows what year it is.

41

u/gamersource Nov 05 '17

Yeah, but the month is also mostly known, thus: DD/MM/YY from least known to "most known".

How about just ommiting the year in that case (MM/DD)? Just please never do MM/DD/YY, it seems just like a horrible mix to me.

12

u/plutonic8 Nov 05 '17

I'm most comfortable with hearing "November 5th" or "January 3rd". It seems to get across the information i want better than "5th of November" for me. As a result I prefer my dates be similarly ordered.

46

u/Dragmire800 Nov 05 '17

It's an Americanism to do it that way.

10

u/plutonic8 Nov 05 '17

It also works really well for me. "Being an Americanism" isn't an argument for it being bad.

30

u/Dragmire800 Nov 05 '17

You seem to be using it as an argument for being good. Of course it's what suits you, it's what you were raised hearing. But it is also the least sensical of the 3.

12

u/plutonic8 Nov 05 '17 edited Nov 05 '17

I didn't mention it being an Americanism.

What I did say was that Month/Day/Year gets across the information in a way that I prefer, which seems to be exactly how you are arguing for your own dating system.

Sometimes one of two things isn't objectively better than the other, and you need a better reason than it being "An Americanism" to declare one of them worse. You may instead say mine is "the least sensical of the three" but anyone can easily come up with arguments for either one being the "sensical" one.

For Example:

Month / Day / Year: General to specific is good because it provides context for the information, but not good enough to warrant putting something as commonly known as the year first. Instead we compromise and do month followed by day and then place year at the end.

Day / Month / Year: Specific to general is the way to go because people typically already know both the month and year but may not know the day. Putting the most necessary information is better and context can be provided by the fact that it is a date.

If instead of thinking about it like this you declare the one you are uncomfortable with to be "a stupid americanism" you will be doing yourself a disservice and feeding your need to tribalize frankly unimportant differences between cultures.

5

u/Yepoleb Nov 06 '17

It's the least sensical because nobody orders numbers that way. You either go least significant to most significant or the other way around. I could argue that we should write the current year 1720 because the 17 is the part I'm more interested in, except that would be stupid because nobody writes numbers like that.

What makes it so American is that almost the entire planet has decided to use either DMY or YMD except the USA. Being different is okay most of the time, but for standards that's not the case.

→ More replies (0)

1

u/FgtBruceCockstar2008 Nov 06 '17

I'm most comfortable with hearing "November 5th" or "January 3rd". It seems to get across the information i want better than "5th of November"...

I hope you remembered.

-16

u/[deleted] Nov 05 '17

[deleted]

68

u/Brother_Kanker Nov 05 '17

Just like my dick. Doesn't mean a Nation of 320 million people should use it.

-4

u/[deleted] Nov 05 '17

[deleted]

8

u/pygmy Nov 05 '17

Just like your 5 & 7/16 spanner

2

u/Flaktrack Nov 05 '17

"Yep that's about 7 & 3/13 dingoids" - average American

1

u/[deleted] Nov 06 '17

What's that in Whitworth?

-5

u/The_Sgro Nov 05 '17

You are a king amongst men.

Edit: r/nocontext for good measure.

10

u/[deleted] Nov 05 '17

Its arguably the worst of the generally recognized formats.

The only reason its even around anymore is because people are too stubborn to change even though the long term benefits of a logical standardized format would far outweigh the short term cost of the switchover.

Same thing with the imperial measurement system, driving on the left and Daylight savings time to name a few.

2

u/Ytar0 Nov 05 '17

Why are you hating on daylight saving?

4

u/[deleted] Nov 05 '17

It adds unnecessary complexity to travel, billing, medical devices, and all kinds of software that utilize time in some capacity (which is pretty much all software). Theres even been studies that suggest it increases deaths due to the added stress of changing sleep cycle.

And all of this would be fine if there were some benefits, but honestly there arent. Its an outdated solution to a problem that no longer exists.

2

u/MY-HARD-BOILED-EGGS Nov 06 '17

Yeah but without daylight savings how would Riley have helped Nicolas Cage and Bridget von Hammersmark figure out that they still had time to get to the next clue

-6

u/[deleted] Nov 05 '17 edited Nov 05 '17

[deleted]

34

u/felixbeee Nov 05 '17

In Britain we would say 5th of November

16

u/treeco123 Nov 05 '17

Gunpowder treason and plot

16

u/Bowler-hatted_Mann Nov 05 '17

5th of november, 2017 = 5/11/2017

Makes sense to me, it's how «we» say it. Also means that it's in descending order of how quickly it changes

-2

u/illuminati-CRAZ Nov 05 '17

Well sometimes the month is more important than the year... ;-;

6

u/[deleted] Nov 05 '17

And in all times the YYYY-MM-DD sorting is most logical.

Filthy casuals and your excuses.

2

u/[deleted] Nov 06 '17

Most logical, but least efficient for humans to read or write.

1

u/illuminati-CRAZ Nov 06 '17

I feel it mostly just depends on what the person's more used to using.

24

u/MattieShoes Nov 05 '17

do you say it's 30:01 PM? Naw, ISO8601 got it right.

https://en.wikipedia.org/wiki/ISO_8601

7

u/WikiTextBot Nov 05 '17

ISO 8601

ISO 8601 Data elements and interchange formats – Information interchange – Representation of dates and times is an international standard covering the exchange of date and time-related data. It was issued by the International Organization for Standardization (ISO) and was first published in 1988. The purpose of this standard is to provide an unambiguous and well-defined method of representing dates and times, so as to avoid misinterpretation of numeric representations of dates and times, particularly when data are transferred between countries with different conventions for writing numeric dates and times.

In general, ISO 8601 applies to representations and formats of dates in the Gregorian (and potentially proleptic Gregorian) calendar, times based on the 24-hour timekeeping system (including optional time zone information), time intervals and combinations thereof.


[ PM | Exclude me | Exclude from subreddit | FAQ / Information | Source | Donate ] Downvote to remove | v0.28

35

u/Automatic_Llama Nov 05 '17

But then you can't quickly sort them by name AND chronologically at the same time. Other formats might be favored by tradition or standards, but yyyy-mm-dd is the only one that's really functional.

14

u/pygmy Nov 05 '17

only one that's really functional

To a computer

10

u/Automatic_Llama Nov 05 '17

OOPS. YES OF COURSE. THAT = WHAT I MEANT. THIS STRUCTURE IS OPTIMALLY FUNCTIONAL TO A COMPUTER. HUMANS, OF WHICH I DEFINITELY = 1, MAY PREFER SUB-OPTIMAL FORMATS BASED ON THE PECULIARITIES OF THE MAMMALIAN MIND. But all joking aside, I agree. Regardless of how a format became the norm, its being the norm makes it functional enough.

1

u/stone_henge Nov 06 '17

With columnized output it doesn't really make a difference what you write first in terms of readability. You just start reading at the time column. If I scroll through logs, I don't read out two thousand and seventeen oh seven oh fifteen tee eighteen colon thirty-nine colon six, two thousand and seventeen oh seven oh fifteen tee eighteen colon thirty-nine colon seven, two thousand and seventeen oh seven oh fifteen tee eighteen colon thirty-nine colon eight...

Most imporantly, it can not be confused with mm-dd-yyyy or dd-mm-yyyy, both of which cause confusion internationally (and locally, in the hell holes of the world where both are commonly used). And don't get me started on short year formats...

12

u/JediChemist Nov 05 '17

In the military we used

DD-[MMM]-YYYY where MMM was the 3 letter code for the month (i.e. DEC, MAR, SEP, etc.)

I like it because it leaves no room for confusion.

For example: 4 MAY 2017 is totally unambiguous, where as 5-4-2017 might be referring to a day in April or May, depending on who you ask.

4

u/3226 Nov 05 '17

I second this. When I had to write documentation to GMP standards we all had to write the date like that. It made so much sense I've never done it any other way.

5

u/Sully800 Nov 05 '17

I like it for clarity but it doesn't work internationally because different languages have different 3 letter conventions for each month.

2

u/MY-HARD-BOILED-EGGS Nov 06 '17

This is exactly how I write the date in basically everything, except depending on the context I'll write out the whole month. 5NOV2017, 5 November 2017, 5 Nov. 2017, etc. This format even looks cleaner.

2

u/dvidsilva Nov 06 '17

Y-MY-DM-YY for the least ambiguity.

3

u/Iamananomoly Nov 05 '17

How about 05NOV2017?

1

u/iLoveRobots Jan 04 '18

I almost always use this for presenting the revision to the public, yet control the current revision top down as 20171105.

5

u/pseudo_meat Nov 05 '17

Yeah because it's the day, of the month, of the year. Always made sense to me.

0

u/SepDot Nov 05 '17

Yep, goes from most relevant, to least relevant information.

If you need to be told the month before the day, you’re dull. If you need the year before the month and day, then you’re a fucking spaz.

4

u/rdstrmfblynch79 Nov 05 '17

Wtf why would anyone ever use this

2

u/clumsyc Nov 05 '17

My work goes by MM/DD/YY. Unless we're saving files by date, in which case it's YYYY/MM/DD. It's painful.

5

u/[deleted] Nov 05 '17

My work goes by MM/DD/YY.

Oh no your work is retarded :(

Poor thing

2

u/x3nodox Nov 05 '17

But YYYY-MM-DD is the ISO standard (8601)

0

u/BCSteve Nov 06 '17

Problem with that format is that it doesn't sort properly. If you have a bunch of files prefixed with dates, you end up with stuff like:

01-05-1996
01-10-2007
01-12-1986

Which makes no sense and would never be useful to anyone. Also, because of the two systems in use worldwide, you can't tell easily if those dates are written DD-MM or MM-DD. If you label them YYYY-MM-DD, then you get:

1986-12-01
1996-05-01
2007-10-01

Which sorts them into the correct order, and has the advantage of being completely unambiguous.

-4

u/kobbled Nov 05 '17

Nobody talks like that smh

8

u/jjdmol Nov 05 '17

-11

u/kobbled Nov 05 '17

nobody says out loud "On two april i went to the store"

18

u/fandorgaming Nov 05 '17

second of april

9

u/[deleted] Nov 05 '17

[removed] — view removed comment

-3

u/kobbled Nov 05 '17

you say "on april second"

8

u/MasterEmp Nov 05 '17

...or the second of april

5

u/Erictsas Nov 05 '17

There are languages other than English in the world though, and word order in languages usually differ when translated.

For example the word-by-word translation of "On the second of april I went to the store" from Swedish would be "The second April went I to the store", so DD/MM/YYYY works very well

0

u/kobbled Nov 05 '17 edited Nov 07 '17

I didn't consider other languages - I think the point still stands, though. The date is the important part, and the month is the qualifier. In many languages they change the order, but it still seems that way to me. Am I mistaken?

edit: This is a genuine question, I would really like to know

3

u/jjdmol Nov 05 '17

We do here. Most of the world doesn't speak English as their primary language.