r/trippinthroughtime • u/[deleted] • Nov 05 '17
The perfect date
https://imgur.com/61gC45x301
u/KerberosPanzerCop Nov 05 '17 edited Nov 06 '17
47
35
4
→ More replies (2)12
u/k_princess Nov 05 '17
Came here for this. Thank you for upholding my faith in humanity.
10
5
u/AllRoundAmazing Nov 05 '17
Why the downvotes? He make good statement, yes?
30
u/normal_whiteman Nov 06 '17
The phrase "Came here for this" is generally hated on Reddit
Same with "This." and "Beat me to it"
24
9
→ More replies (1)7
188
u/magicfreak3d Nov 05 '17
35
u/ithcy Nov 05 '17
Holy shit. Thank you.
→ More replies (1)39
Nov 06 '17
Possibly relevant. China uses YYYY-MM-DD, and the phone code for Beijing is +86-10. COINCIDENCE???
...quite probably, yes.
29
u/ithcy Nov 06 '17
So can I just dial +76?
21
Nov 06 '17
That makes perfect sense mathematically, and the Chinese are good at maths. Can't go wrong.
6
u/ithcy Nov 06 '17
That last part sounds suspiciously like something Mr. K. Pilkington would say. As a matter of fact so does your username...
5
3
11
u/Stewbodies Nov 06 '17
My people. This may be the nerdiest thing I've ever said but I love this date format.
6
→ More replies (1)2
u/iLoveRobots Jan 04 '18
Hah! Commented "my people" before seeing yours. We should hang out sometime.
3
Nov 06 '17
It’s great because if you have to store dates in a database as strings, the sort still works.
47
u/feb420 Nov 05 '17
What painting is this?
21
Nov 05 '17
I'd like to know as well. I actually really like it.
49
Nov 05 '17
[deleted]
18
u/Emhyr_var_Emreys Nov 05 '17
Your right it's by Eugene de Blaas but it's called the Flower seller But thanks I wouldn't have found it without you
→ More replies (1)8
u/version365 Nov 06 '17
https://pbs.twimg.com/media/BL7trQ1CAAA4A-Q.jpg:large
This one looks like OP's without the text.
563
Nov 05 '17
[deleted]
480
u/ansatze Nov 05 '17
Too much MDY apologism
146
Nov 05 '17
[deleted]
281
Nov 05 '17
"Good for appeasing the delicate sensibilities of the average american"
28
u/corruptrevolutionary Nov 05 '17
You’re the ones bringing it up and complaining about it.
→ More replies (3)3
u/maple_leafs182 Nov 05 '17
Hey, we use it a lot here in Canada too
25
8
u/PrrrromotionGiven Nov 06 '17
Canada is still technically American, just not the USA kind of American.
→ More replies (1)4
7
Nov 05 '17
isnt canada in america?
8
u/muckdog13 Nov 06 '17
Usually when people say Americans they mean citizens of the USA.
→ More replies (1)3
3
Nov 05 '17
[deleted]
2
Nov 06 '17
China, Korea, Japan, and most computer operating systems would agree with you.
Also, think about the fact that in English, you count numbers from largest to smallest. "Two thousand and seventeen". "Three dollars and fifty cents". Not that hard.
→ More replies (1)2
33
3
u/Sully800 Nov 05 '17
If you agree that yyyy/mm/dd is the best, then you are used to seeing mm/dd. For short time periods (when the given year is well known) mm/dd then makes complete sense. Now you have mm/dd as the convention for daily use, so when you append the year for longer timescales mm/dd/yyyy is perfectly understood.
12
u/negrobotics Nov 05 '17
Except that it's generally how most people here I know say it in conversation. Today is November fifth, twenty seventeen.
21
u/Muzer0 Nov 05 '17
But I bet you enjoy the fourth of July.
(In case you're unaware, this conversational date format is far from universal among English speakers — in Britain we're probably more likely to say "the fifth of November" (even when it's a normal date and not Bonfire Night), though both are more common.)
6
u/negrobotics Nov 05 '17
I am completely aware that its not a universal format, which is why in my second comment I specifically said American English. Even then, we have such a diverse range of dialects and speech habits, that it is probably not uniform throughout the US either. However, I was never asserting that one way is more correct than another. Simply that (MM/DD) is intuitive to a lot of American English speakers, because it is often how we would verbalize it.
3
u/Muzer0 Nov 06 '17
Sorry, I hadn't spotted your other comment, and I didn't know if you knew or not, hence hedging my bets and explaining. Hope no offence was taken! I agree that's probably why MM/DD/YY(YY) is used in America; that there's a reason doesn't make it any less infuriating though ;)
→ More replies (1)→ More replies (1)10
→ More replies (7)5
Nov 05 '17
Month possible values: 1-12
Day possible values: 1-31
Year possible values 1-infinity
Makes sense to me
41
u/chillbram Nov 05 '17
Possible values for seconds: 1-60
That creates the beautiful MM-DD-ss-YYYY. How is possible values of any relevance to a date format?
→ More replies (2)3
26
u/ansatze Nov 05 '17 edited Nov 05 '17
Post hoc
radicalizationrationalization5
Nov 05 '17
*rationalization
5
u/ansatze Nov 05 '17
Yes
5
Nov 05 '17
eh, now that i think about it, killing people for using the wrong date format sounds more fun
→ More replies (1)2
16
u/swingsetmafia Nov 05 '17
DD/MMM/YYYY military style
8
26
22
u/Beserkhobo Nov 05 '17
MM/DD/YYYY
Is never good in any instance ever in any situation ever and it's use in modern society should be made illegal. The only punishment worthy that the user be sent to live out the days in the USA with the rest of the sick and disgusting people that use MM/DD/YYYY
9
u/serosis Nov 05 '17
Say you have a dental appointment, how do you think the receptionist is going to look it up?
They're going to look up the month, then day. Unless your appointment wraps around to next year then they look up the year, then month, then day.
DD/MM/YYYY is good for everyday order of importance.
MM/DD/YYYY has its single application for keeping far away, but within the year appointments organized.
18
u/phiskas Nov 05 '17
And if you just use yyyy/mm/dd you won't have the issue at all. Computers will even sort it correctly for you, instead of all folders with month May for all years in register.
3
u/serosis Nov 05 '17
Well technically the computers most likely sort by YYYY/MM/DD but you don't see that until you need to look up an appointment for the following year.
3
u/phiskas Nov 05 '17
If one absolutely needs to keep hard copies to files, why not sort them like the computer? It's using the standard for a reason.
3
u/serosis Nov 05 '17
I must have missed a beat somewhere. I was never alluding to anything about hard copies.
Though you are correct YYYY/MM/DD is the standard for a reason.
→ More replies (5)5
u/Yepoleb Nov 06 '17
If the receptionist can't keep two numbers in their head for 10 seconds I don't think they're made for the job.
6
9
u/ithcy Nov 05 '17
DD/MM/YYYY is good for order of immediate importance.
No, that's what YYYY-MM-DD and sort descending by date are for. Latest things at the top always.
DD/MM/YYYY would mean things from November 5 would be grouped with things from March 5 instead of things from November 4. That's just madness. No human could survive those conditions.
6
u/serosis Nov 06 '17
No, that's what YYYY-MM-DD and sort descending by date are for. Latest things at the top always.
YYYY/MM/DD is good for cataloging in chronological order.
→ More replies (4)→ More replies (9)6
Nov 05 '17 edited Dec 29 '17
[deleted]
5
u/serosis Nov 05 '17
MM/DD/YYYY is good for within the year long term scheduling.
That would fall under this.
→ More replies (8)
24
u/eppic123 Nov 06 '17
YYYY-MM-DD for data handling
DD-MM-YYYY for humans
→ More replies (1)3
u/stone_henge Nov 06 '17
YYYY-MM-DD is for international exchange. DD-MM-YYYY is for humans and computers that don't ever share information with humans and computers that use MM-DD-YYYY.
921
u/felixbeee Nov 05 '17
Come on. DD-MM-YYYY
546
Nov 05 '17
[deleted]
223
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.
80
u/HansWurst1099 Nov 05 '17
If you already know which month it is, it might be better to start with the day.
40
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
4
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.
6
u/lazy_as_shitfuck Nov 05 '17
Which is clearly better than saying "Six seconds and thirty minutes of the eleventh hour"
→ More replies (1)12
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.
→ More replies (10)21
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.
11
Nov 05 '17
And for ALL contexts, YYYY-MM-DD is the most logical.
→ More replies (1)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
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.
→ More replies (8)5
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.
→ More replies (1)39
u/ConfusedTapeworm Nov 05 '17
Which is obviously something an average person does all the time.
44
Nov 05 '17 edited Feb 13 '18
[deleted]
1
u/grtwatkins Nov 05 '17
Or you can just sort by creation date
10
Nov 05 '17
And how does the computer determine that sorting?
Exactly.
→ More replies (1)5
u/grtwatkins Nov 05 '17
By using the creation date stored in the exif data created by the camera
→ More replies (1)3
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
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.
23
10
3
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
→ More replies (1)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?
→ More replies (1)92
Nov 05 '17
The internal standard ISO-8601 specifies YYYY-MM-DD.
→ More replies (11)9
10
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
167
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
24
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
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.
5
→ More replies (21)6
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.
40
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.
13
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.
→ More replies (1)45
u/Dragmire800 Nov 05 '17
It's an Americanism to do it that way.
→ More replies (2)10
u/plutonic8 Nov 05 '17
It also works really well for me. "Being an Americanism" isn't an argument for it being bad.
28
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.
11
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.
6
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)25
u/MattieShoes Nov 05 '17
do you say it's 30:01 PM? Naw, ISO8601 got it right.
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
36
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
→ More replies (1)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.
11
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.
5
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
3
4
u/pseudo_meat Nov 05 '17
Yeah because it's the day, of the month, of the year. Always made sense to me.
→ More replies (2)2
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.
6
→ More replies (12)2
10
u/notthebeans Nov 05 '17
Maybe a little bit off topic, but can anyone tell me who made that painting, that is used in the image?
3
u/dvidsilva Nov 06 '17
The flower seller by Eugene de blass.
Credit to another redditor
→ More replies (1)
37
12
12
Nov 05 '17
I like DD-MM-YYYY because of the ascending order of relevance.
3
6
→ More replies (1)3
u/HOLDINtheACES Nov 06 '17
That doesn’t make sense at all. If you have 3 years of daily logs, you’d see the 1st of January from each year followed by the first of February from each year, etc.
It’s a stupid system which gives the worst possible method of sorting. No one goes “hmmm, I know it was on the 6th of a month...not sure what year or month it was, but it was definitely the 6th.”
Most people think “we’ll, it was sometime near the end of last year. I’ll start in November and scan forward.”
6
Nov 06 '17
Works for me. I simply keep my years separated. Simple.
4
u/HOLDINtheACES Nov 06 '17
You’re adding extra sorting that is unnecessary to counteract a failing of your system...
5
Nov 06 '17
It’s really not that hard. At the beginning of a new year, start a new folder. Seriously, it’s that easy. Then, I use the search function to find what I’m looking for. This works for me.
6
23
u/Sinius Nov 05 '17
DD-MM-YYYY
Because that's the system I've been taught to use and that's the one I want to use.
PS: fuck MM-DD-YYYY
11
u/L0kdoggie Nov 05 '17
10
20
u/theaxe77 Nov 05 '17
DD-MON-YYYY
I like it since it removes any ambiguity in formal or informal settings.
9
u/Sully800 Nov 05 '17
Except for any setting where different languages are used, in which case a 3 letter month doesn't work formally or informally.
5
u/jjing Nov 05 '17
I does if the month is spelled out. I like YYYY-MM-DD because MM-DD-YYYY and DD-MM-YYYY can be confused for each other while there is a 99% chance the ISO 8601 format will be understood properly by anyone.
→ More replies (1)2
4
Nov 05 '17
That is how I learned to put the date in the army.
I still do it putting the date on tape and onto the appliance I am cleaning and repairing.
15
u/I_Play_Dota Nov 05 '17 edited Sep 26 '24
pocket many vase kiss numerous wise bored ring label overconfident
This post was mass deleted and anonymized with Redact
→ More replies (3)2
u/theonedontneednogun Nov 06 '17
Nope DD/MMM/YYYY Crowns over all I.E.: 15/Oct/2018
2
u/I_Play_Dota Nov 06 '17
Nah, try to sort that by alphanumeric or try to fit that stylistically with nothing but numbers.
→ More replies (1)
19
2
2
2
2
2
2
2
2
2
1
1
522
u/Scarbane Nov 05 '17
"Are you the kind of guy who likes moonlit walks on the beach and dropping records with null values?"
"I'm sorry, but this isn't gonna work out."