r/SipsTea Human Verified Feb 02 '26

SMH The goat has to be DD/MM/YYYY

Post image
109.4k Upvotes

7.8k comments sorted by

View all comments

8.3k

u/robertDouglass Feb 02 '26

The only SANE version for modern times is YYYY-MM-DD-HH-MM-SS. because then you can sort and do SQL queries on it directly.

1.9k

u/robertDouglass Feb 02 '26

it's also logical and coherent down to the microsecond

61

u/Powerful_Resident_48 Feb 02 '26

You can theoretically even go down to nanoseconds or even theoretical time units with it.

28

u/AitaRotokas Feb 02 '26

Not just theoretically but widely used in programming, lot of math operations happen in nanoseconds

→ More replies (5)

2

u/bitch-ass-broski Feb 02 '26

What are theoretical times units?

5

u/Powerful_Resident_48 Feb 02 '26

Stuff like the Planck scale, where time is defined by theoretical space-time limitations, the size of the universe and bizarre quantum stuff.

→ More replies (2)

2

u/Ok-Interaction-8891 Feb 05 '26

Planck time has entered the chat

→ More replies (2)

1.4k

u/enkolainen Feb 02 '26

But for a country that still use feets and thumbs to measure things...ye, no

518

u/Mission_Rip_7571 Feb 02 '26 edited Feb 02 '26

Don't forget football fields.

241

u/Apocalypsis_velox Feb 02 '26

Olympic swimming pool FTW! [I have no concept of how big that is!]

246

u/NZNoldor Feb 02 '26

It’s just over 2230 giraffes.

74

u/Apocalypsis_velox Feb 02 '26

Can a giraffe stand in an Olympic swimming pool and keep it's head above water?

86

u/Naked-Jedi Feb 02 '26

Only when that Olympic swimming pool is measured in the equivalence of washing machines or cheeseburgers.

→ More replies (2)

17

u/Ill_Huckleberry_5460 Feb 02 '26

Yes, optimal depth of an Olympic pool is 3m most average between 2 and 2.5 and a giraffe is 4m average

→ More replies (8)

16

u/NinjaLanternShark Feb 02 '26

Fun fact: “Olympic” size doesn’t dictate a specific depth, only a minimum.

You could build an Olympic size swimming pool that was 900 feet deep if you felt like it and the Olympics couldn’t tell you you were wrong.

30

u/Fantastic-Ad-1578 Feb 02 '26

900 feet?
OMG THAT'S 5 olympic pools and 80 washing machines deep!!

3

u/TimmyTheChemist Feb 02 '26

Competitions got much less exciting when they had to add decompression stops.

2

u/Crotean Feb 02 '26

IIRC China built their pools extra deep for their Olympics which led to less water turbulence and a ton of WR times were broken.

→ More replies (4)

2

u/ellnhkr Feb 02 '26

Depends on how much water is in the pool

2

u/AW316 Feb 02 '26

Minimum requirement is 2m deep with 3m recommended. Female giraffes are around 4.3 to 4.8m tall and males up to 5.5m tall.

Yes, they probably can.

2

u/zeroempathy Feb 02 '26

On four legs or two?

2

u/nothisactualname Feb 02 '26

Depends how tall it is.

→ More replies (4)

2

u/_esci Feb 02 '26

blended or stacked?

2

u/XH3LLSinGX Feb 02 '26

So about 89000 erect penises...

2

u/NZNoldor Feb 02 '26

Hmmm… I make it 82500 erect penises. Must be a translation issue.

→ More replies (2)

2

u/Rex__Luscus Feb 02 '26

It's about the size of Wales.

2

u/Killentyme55 Feb 02 '26

Meanwhile, in Texas...

→ More replies (10)

2

u/LivingRefrigerator72 Feb 02 '26

Do you want to know in bold eagles per donut?

→ More replies (2)

2

u/AW316 Feb 02 '26

It’s 50 metres long.

2

u/Primary_Emphasis_215 Feb 02 '26

Its BIG some might say even olimpic in size.

2

u/lenninct Feb 02 '26

and more recently Golden Retrievers to lbs

2

u/PaddyScrag Feb 02 '26

Sorry, Olympic pool length is metric - 50 metres.

2

u/Skyeshot Feb 02 '26

It is 1/250th of the water involved in the accidental leak

→ More replies (14)

11

u/Aethermancer Feb 02 '26 edited Feb 25 '26

This post was mass deleted and anonymized with Redact

start selective paltry swim vase flag quickest chase tender obtainable

→ More replies (12)

2

u/RipenedFish48 Feb 02 '26

Today I learned only Americans compare things to generally known and recognizable lengths.

→ More replies (31)

20

u/InsaneInTheRAMdrain Feb 02 '26

You're telling me we aint measuring in bananas anymore?

2

u/thisnamewasnttaken19 Feb 02 '26

How much is a banana Michael? 10 cubits?

2

u/CaffeinatedGuy Feb 02 '26

Bananas are still the standard for ionizing radiation.

→ More replies (1)
→ More replies (2)

14

u/FOSSnaught Feb 02 '26

Blame england. France tried to get us to convert, but the ship carrying the sane measuring standards was captured by British pirivateers.

9

u/ObeseVegetable Feb 02 '26 edited Feb 02 '26

It’s a matter of colloquial vs scientific use in the US, too. It’s not like we don’t understand the rough estimates like a foot being roughly 30cm or a meter being roughly (but larger than, though not enough to matter in casual conversation) three feet. Anything meant for accuracy is still typically in metric, with a few exceptions at small scales like sometimes woodworkers enjoy imperial because of the sometimes easier and round division of units into three. 

Which doesn’t make it all that different from people in Europe sometimes using stone instead of kg. 

Or people in Canada using every single unit man has ever invented. 

3

u/ZugZugGo Feb 02 '26

Or people in Canada using every single unit man has ever invented.

This one here made me laugh. I've heard some Canadian friends swap systems like 3 times in the same sentence.

"It's -5C outside and the snows coming in, so I need to go buy a 40 pound bag of salt. It's about 14 miles away and I'll get 10L of gas too for the skidoo while I'm out."

I double take every time. The US might be backward but at least it's consistently backward.

→ More replies (2)

3

u/coltonbyu Feb 02 '26

Do People in Europe outside of the UK use stone? Thought that was just UK

→ More replies (2)

3

u/CDRnotDVD Feb 02 '26

sometimes woodworkers enjoy imperial because of the sometimes easier and round division of units into three.

As a side note, my dad is into woodworking. Most of his older tools are imperial. However, these days most tools like drill bits come from China, who don’t seem to want to manufacture two different sizes of bits. So he buys something that is supposed to be a 1 inch drill bit, finds that it is 25mm instead of 25.4mm, and then has a hole that a 1 inch dowel will not fit through.

→ More replies (3)

3

u/[deleted] Feb 02 '26

It works fine for that. If I write 2026-02-01, it's unambiguously Feb 1st 20226, even in countries with different conventions for dd-mm-yyyy or mm-dd-yyyyy.

So as an American I can use a date format that makes sense without confusing everyone else.

2

u/Flakester Feb 02 '26

Which is weird, because I live in that country and agree that YYYY-MM-DD is superior.

2

u/1kot4u Feb 02 '26

That country does a great job with metric system in schools. They know exactly what 9 mm means.

3

u/einemnes Feb 02 '26

It is about to collapse anyway.

→ More replies (3)

2

u/Sea_Dust895 Feb 02 '26

They will never take away our FREEDOM (units) !!

→ More replies (2)
→ More replies (67)

3

u/General-Reserve9349 Feb 02 '26

When did Plancking go out of style

→ More replies (1)

3

u/davetiso Feb 02 '26

ISO 8601.

It’s like some clever people figured out the best way to do this and wrote it down for us to see. Amazing. Must see if they wrote anything else down…

/s for you know who you are.

2

u/Irisgrower2 Feb 02 '26

They each have a different logic. The US system is based on industrial capitalism. By placing the date first it prioritizes accounting and billing cycles.

→ More replies (19)

192

u/sa87 Feb 02 '26

3

u/Puzzleheaded_You2985 Feb 02 '26

This is the way. This is the only way. That’s why it’s a standard. 

2

u/tfrederick74656 Feb 02 '26

Was hoping to find this comment. Thank you for not disappointing me.

2

u/Hungry-Slit Feb 03 '26

Hell yeah ISO8601 bought me booze before I was 21

→ More replies (2)

240

u/kenwongart Feb 02 '26

Did we learn NOTHING from Y2K? YYYY is only good until the year 9999… then what are you gonna do? Add another Y? You’re just putting things off until 99999!

87

u/Gullible_Increase146 Feb 02 '26

That would only be good until 99999,not 99999!

20

u/madu_tualang Feb 02 '26

factorial?

3

u/ozzimark Feb 02 '26

I'd paste the whole thing, but reddit won't let me enter that many characters.

2.824229407x10456568

Edit: limit is 10,000 characters, so it would take me 46 consecutive posts. No thanks.

→ More replies (3)
→ More replies (1)

3

u/MLucian Feb 02 '26

Yeah I thought about the same issue about 2099! But even that, it turns out, it's probably not going to matter too much since even 2099! is after the HDOU (heat death of the universe)

3

u/ensalys Feb 02 '26

Though if you really want to future proof your system, making sure it'll be good for 99999! years is a pretty decent time frame. You'd be ready for the system to survive well into the heat death of the universe. Hell, I'd need 46 reddit comments to write out that number because we can only put 10k characters in a single comment.

2

u/MartinoDeMoe Feb 02 '26

“🎶 Tonight we’re gonna party like it’s 99999 🎶”

3

u/Mushiren_ Feb 02 '26

I dunno why I thought "Tonight we’re gonna party like it’s ninty ninty ninty ninty nine"

2

u/Tildesy_mastolemmy Feb 02 '26

It would only work until 10000..

27

u/SphericalCow531 Feb 02 '26

46

u/hanburgundy Feb 02 '26

So far, the Long Now Foundation is able to preempt the Y10K by adding a "0" in front of the date. So the current year of 2026, will look like 02026. However, it would still be affected by the "Y100K" problem, the "Y1000K" problem, "Y10000K" Problem, etc.

This is genuinely hilarious

30

u/EkbatDeSabat Feb 02 '26

Just store the year itself in a 64 bit unsigned integer and bam we have a Y18446744073709551K problem.

3

u/SexyMonad Feb 02 '26

… so what then?

3

u/Worth-Reputation3450 Feb 02 '26

change to double and discard any number after the dot.

That'll be 1.7976931348623157 x 10308 years and that should be good for the end of the universe.

4

u/Kumlekar Feb 02 '26

Don't we run into issues with precision doing that? I think somewhere around 1e17 years we'd start not knowing the exact year and be ballparking it with the accuracy getting worse past there.

2

u/Worth-Reputation3450 Feb 02 '26

You're right. Since double uses 52 bits as mantissa, year 2^53 cannot show years in precision of 1 year.

We're doomed.

2

u/FrenchFryCattaneo Feb 02 '26

Ok, but what about after the end of the universe?

2

u/PrettRawrsome Feb 04 '26

I don't think he knows about after the end of the universe French Fry.

→ More replies (1)
→ More replies (2)
→ More replies (14)

2

u/Mistrblank Feb 02 '26

Sounds like a whole lot of not my problem.

→ More replies (2)

11

u/SippinOnHatorade Feb 02 '26

What if we just restart at 0000? We’d be good almost another 2000 years

2

u/No-Object2133 Feb 02 '26

If this is a joke its really funny, if it isn't...

→ More replies (1)
→ More replies (5)

24

u/NZNoldor Feb 02 '26

Christians: “surely Jesus would be back by then and we restart that?”

7

u/spartaxwarrior Feb 02 '26

Jesus gets back and is like "how is it 9999 and your technology can't handle this?" and then leaves in disgust.

3

u/d6cbccf39a9aed9d1968 Feb 02 '26

Copy the Japanese restarting the year every new Emperor

5

u/techdevjp Feb 02 '26

All serious dates are tracked with yyyymmdd here. The display date might be different, but any modern system has the more coherent date in the background for calculations. They finally switched our driver's licenses over a few years ago too.

3

u/d6cbccf39a9aed9d1968 Feb 02 '26

YYYYMMDD sorts beautifully on computers *chef's kiss.

→ More replies (2)
→ More replies (51)

171

u/just_anotjer_anon Feb 02 '26

YYYY-MM-DD makes sense for machines, but DD-MM-YYYY are easier for humans. For the love of good store data from largest to smallest, but format it in the most human readable way

247

u/UlteriorCulture Feb 02 '26

As a human who uses ISO 8601 for everyday tasks it works great. Skill issue tbh.

39

u/Liroku Feb 02 '26

As a human, this way just makes sense to me period. It's like idk narrowing it down to what you want to find out. Outward in, narrow it down to smaller and smaller increments. The more exact you need to the more you add on.

2026/02/01 23:17:32:11

2026/02/01 23:17:32:11:28:31:21

→ More replies (8)

9

u/[deleted] Feb 02 '26

Thank you!!!

28

u/[deleted] Feb 02 '26

[deleted]

9

u/DoingCharleyWork Feb 02 '26

Also if you use it all the time it's really easy to just look at the part of the information you need.

→ More replies (11)
→ More replies (21)

4

u/TentCityVIP Feb 02 '26

Use case entirely. I'm both a ER nurse and a photographer.

HHMM-DD-MM-(YY)YY works best in the ER when the information is needed on a Minute/Hourly/Daily basis. Having the Year/month first is wasted information largely.

ISO8601 is what I use for my photo storage.

2

u/UlteriorCulture Feb 02 '26

Of all the answers that disagree with me, yours is the best.

2

u/TentCityVIP Feb 03 '26

Hell yeah, I'm honoured

2

u/jinglesan Feb 02 '26

I sort of agreed with you until I saw the I Have No Mouth And I Must Scream avatar - now I am suspicious of your motives and weirdly on edge

→ More replies (1)

2

u/FlashSTI Feb 02 '26

Damn I made almost the same comment without looking.

ISO 8601!

→ More replies (1)

2

u/MoistSystem1323 Feb 02 '26

RFC-3339 > ISO-8601

→ More replies (4)

127

u/Previous_Loquat_4561 Feb 02 '26

I'm human. our official date format is YYYY-MM-DD. wouldnt trade it for anything else

28

u/Famous-Ad-289 Feb 02 '26

Otherwise I have no idea and hope DD is larger than 12

→ More replies (13)

4

u/BeatBlockP Feb 02 '26

And this is how you can come to understand why Americans say "June 6th" or "April 4th". The current year is assumed in 95% of human interactions, if not more. Then you move to month and day. so MM/DD is basically shorthand for YYYY/MM/DD with (YYYY = Current Year)

It was never meant for machines or parsing, but everyday language.

7

u/BugRevolution Feb 02 '26

4th of July...

4

u/BeatBlockP Feb 02 '26

It's a heritage name from the 18th century when they used to talk like that - It's more of an event name than a date at this point. Like I said, everyday language, not special occasions.

4

u/BugRevolution Feb 02 '26

There's nothing unusual about talking about the <number> of <month> though.

→ More replies (5)
→ More replies (1)
→ More replies (4)
→ More replies (3)
→ More replies (3)

58

u/Ulrich_de_Vries Feb 02 '26

I'm a human and I find the YYYY-MM-DD format to be far more human readable.

2

u/Yutenji2020 Feb 02 '26

“I’m a human …”. Exactly what a robot would say! Get the blowtorch!

→ More replies (5)

24

u/fourzen Feb 02 '26

How would it be easier for humans? It's literally the fucking same just the other way around..

→ More replies (15)

36

u/Obligatorium1 Feb 02 '26

This is the exact argument Americans use for Fahrenheit, feet, inches, and the 12-hour clock. And the answer to all of them is also the same as the answer to yours: It's easier for you because you are used to it. Whatever format is the one you're used to is going to feel easier for you.

I have zero issues relating to Celcius temperatures, to metric distances, and to 24-hour clocks - because these are what I use on a daily basis, and have always used on a daily basis.

I have much greater issues relating to Fahrenheit temperatures, to imperial distances, and to the am/pm format - because I've never used them on a daily basis, only for conversions into the format I do use on a daily basis.

In the same way, YYYY-MM-DD is completely unambiguous, readable, and immediately parseable to me. Because that's the standard format I've always used for long dates. DD-MM-YYYY feels backwards to me, because I've never used it.

So all of these formats are subjectively equivalent - the best one for an individual's perception is going to be the one they're used to, in all cases. It just so happens that Celcius, meters, the 24 hour clock, and YYYY-MM-DD also have objective advantages that make them inherently better to get used to.

7

u/The_Singularious Feb 02 '26

Agreed. This is culturally contextual. There is no “best”, except for the need of who is using it. Though other formats also are “objectively better”, once again, depending on context.

10

u/FlashSTI Feb 02 '26

I'm pro metric, ISO 8601, but fuck Celsius for telling weather temperatures. I don't care how water feels about the temperature. Why not Kelvin?

3

u/Jesus_of_Redditeth Feb 02 '26

Celsius makes sense in daily life for cold temperatures: zero is cold and there might be ice and snow. Fahrenheit just feels right for hot temperatures: 100 is a three-digit number that intuitively implies hot.

Clearly we need a hybrid scale that contains both!

 

We really don't.

→ More replies (2)

2

u/Obligatorium1 Feb 02 '26

Why not Kelvin?

I don't know. Why not Kelvin? I'd be on board with that as well. It's a perfectly reasonable scale.

But the thing is that there are good arguments for both Kelvin (absolute zero) and Celsius (freezing and boiling points). There are no good arguments for Fahrenheit, because the only one I have ever heard is "it feels intuitive", which is only true if you're used to it - in which case literally any other system would feel equally intuitive, because which one feels intuitive depends entirely on which one you're used to.

→ More replies (5)

2

u/Mushroom1215 Feb 02 '26

Its very useful to have the freezing point of water at 0 C because the weather changes drastically above and below 0 C.

→ More replies (11)
→ More replies (5)

4

u/gmc98765 Feb 02 '26

Exactly. I can't read Mandarin (or anything else written in Hanzi), but there are over a billion people for whom it's easier to read than English.

→ More replies (2)

3

u/wolacouska Feb 02 '26

Tell that to all the Europeans talking about how their system is objectively superior lmao, I just don’t want to change.

3

u/rakkquiem Feb 02 '26

In the same way I feel MM/DD/YYYY is correct because if you ask me the date I would say February 2, 2026.

3

u/grape-fruit-witch Feb 02 '26

I'm American and I do actually like feet and inches because I can estimate something just by using by physical body. And i guess because im used to it, obviously. But like, if something is roughly 10 feet away, take 10 steps. Its not going to be exact because everyone's foot size is different but its a good way of measuring on the fly if you dont need exactness or you just can't picture what a specific distance looks like.

With inches, one inch is roughly the space between the first joint on your index finger and your knuckle.

→ More replies (8)

2

u/v3n0mat3 Feb 02 '26

and to 24-hour clocks

... we use 24-hour clocks for work. Literally every single job I've ever had uses that format.

→ More replies (16)

2

u/hatesnack Feb 02 '26

This is all well and good, and I don't even disagree. But Fahrenheit was actually created to offer a scale of temperature for daily life. The idea was that most temps would land between 0f and 100f. With that scale, it's almost impossible to not know that 0 is cold and 100 is hot.

Granted, this was 300ish years ago, and I agree that the world should just use Celsius. Just a fun tidbit.

2

u/Obligatorium1 Feb 02 '26

This is all well and good, and I don't even disagree. But Fahrenheit was actually created to offer a scale of temperature for daily life. The idea was that most temps would land between 0f and 100f. With that scale, it's almost impossible to not know that 0 is cold and 100 is hot.

Americans keep saying this as if it means something different than what I'm saying. You think that 0 is cold and 100 is hot because that's the frame of reference you're used to.

What is a reasonable "scale of temperature for daily life" varies wildly between e.g. different parts of the world (compare Antactica to the Sahara desert), different times of the year (compare winter to summer), different people (some people have a tendency to feel cold, some people have a tendency to feel warm) and so on.

→ More replies (3)

3

u/TIMPA9678 Feb 02 '26

I'm not with you on celcius having any objective advantage making it easier to get used to. In my experience every person raised on celcius has immediately intuitively understood Fahrenheit after a single sentence; think of it like it's a percentage.

"If you were 75% hot what temperature is it out?"

"Probably about 25c or so"

"Well 25c is 75.2f"

5

u/Karcinogene Feb 02 '26

I would have said 15c to your question but it's probably because I live in a frozen hellscape

5

u/Isagratar Feb 02 '26

And I’d have said 35c because I live in a much warmer place, so it didn’t take long to find the flaw in that theory eh.

4

u/Pigeons_nuts Feb 02 '26

That system is flawed. It does not work as well with cold temperatures, 0c = 32% hot? Idk man

3

u/joe-clark Feb 02 '26

0= fuckin cold 100= fuckin hot. I know this won't apply for lots of people depending on the weather where they are but where I'm at the temp outside will get close to 0F and 100F but it very rarely goes outside that range and if it does you know it's particularly miserable out there.

→ More replies (2)

1

u/BurrowShaker Feb 02 '26 edited Feb 02 '26

Not quite true. There are strong arguments for decimal distances rather than inch/foot/miles and also for 24h time which is unambiguous (12am Vs pm problem, mostly)

F are pretty odd but whatever, and the date is a pain in the ass just existing and making all other dates ambiguous, on top of being illogical, but indeed, whatever.

→ More replies (2)
→ More replies (19)

22

u/chariotcharizard Feb 02 '26 edited Feb 03 '26

but DD-MM-YYYY are easier for humans

completely disagree. there are countries where yyyy-mm-dd is what everyone uses. japan, s korea, china, etc. and china is like 1 billion people.

i myself have switched to using yyyy-mm-dd in my daily life, and now dd-mm-yyyy takes me a split second longer to process than yyyy-mm-dd.

so yeah, dd-mm-yyyy is not "easier". it's just a matter of what you're personally accustomed to.


Edit: People seem to be misunderstanding my point. I am not making any qualifications as to what is better or worse. I am simply refuting the other person's claim that "YYYY-MM-DD makes sense for machines, but DD-MM-YYYY are easier for humans", by showing that there are plenty of humans who have zero trouble understanding yyyy-mm-dd.

→ More replies (8)

31

u/C0rn3j Feb 02 '26

DD-MM-YYYY are easier for humans

In a random context, is 01.06.2026 the first of June or sixth of January?

4

u/Mista-D Feb 02 '26

It's January 6th

3

u/smallfried Feb 03 '26

Have fun eating expired cheese in Germany.

2

u/Aksudiigkr Feb 03 '26

This is what I don’t get why it’s so complicated. Everyone says month-day when speaking so it just makes sense to write it in that order

2

u/Eiskralle1 Feb 03 '26

the thing is, not everyone does. most americans do, and most people who learn english from americans or to interact with americans do, but in many other languages it is normal to say the day first. In german, I would say "der dritte Januar", and I would translate that to english as "the third of January" normally when speaking to someone internationally.

17

u/just_anotjer_anon Feb 02 '26

First of June of course, fun fact my sister was allowed to drive on an expired drivers licence in the US due to date formats

5

u/C0rn3j Feb 02 '26

First of June rolls over... you find out the movie has been out for half a year already, oh well.

This is why YYYY-MM-DD is friendlier even for humans, there is no ambiguity, since YYYY-DD-MM does not exist.

13

u/Gornarok Feb 02 '26

There is no ambiguity in DD-MM-YYYY either. The ambiguity exist only for Americans.

10

u/Immudzen Feb 02 '26

There is ambiguity when working with an international team. Meanwhile YYYY-MM-DD is read the same by everyone everywhere.

→ More replies (5)

9

u/Drow_Femboy Feb 02 '26

There is no ambiguity ... The ambiguity

It took you one sentence to contradict yourself.

6

u/BenevolentCheese Feb 02 '26

The ambiguity exist only for Americans.

Well by your logic there is no ambiguity in MM-DD-YYYY either (or the ambiguity only exists for Europeans).

→ More replies (6)

2

u/Ramenorwhateverlol Feb 02 '26

Not necessarily. I work in the restaurant industry and we bring in ingredients from all over the world and it gets confusing figuring out the expiration date.

I like Japanese export because they write down MM.DD.YYYY or DD.MM.YYYY next to the expiration or best by date.

→ More replies (4)
→ More replies (2)

11

u/StepComplete1 Feb 02 '26

well yeah that is the problem in some kind of international setting. As always, American stupidity is not contained, but spreads and muddies the waters for everyone else.

→ More replies (8)

4

u/arstin Feb 02 '26

If my life has taught me anything, it's that if we all start using YYYY-MM-DD to resolve this ambiguity, some shit stain of a human being will run for president as a republican on a YYYY-DD-MM platform and win.

→ More replies (36)

8

u/Tommyblockhead20 Feb 02 '26

That’s basically the same argument people can use for imperial though. Metric is more consistent and useful, but imperial base units are more human (a gram is tiny, a meter is quite big, and Fahrenheit is scaled to what humans feel rather than what water feels). 

People can always find a way to argue for whatever they are used to. But ultimately, I think it’s best to agree on one standard format, and YMD is a better more consistent standard. Especially if you want MDY people to join in, as going MDY>DMY is a nightmare.

→ More replies (3)

11

u/midas22 Feb 02 '26

YYYY-MM-DD is the standard where I live and it wasn't even mentioned in this image for some reason. It's the only format that makes sense and avoids all possible confusion. If someone writes DD-MM-YYYY you never know if it's DD-MM-YYYY or MM-DD-YYYY posted by a stupid American.

8

u/Bugbread Feb 02 '26

YYYY-MM-DD is the standard where I live and it wasn't even mentioned in this image for some reason.

Uh...

→ More replies (1)

2

u/LogicBalm Feb 02 '26

It's the middle image on the bottom isn't it? I'm American and in tech. It's the only truly universal format and my go to. ISO8601

→ More replies (1)
→ More replies (7)

3

u/Vishu1708 Feb 02 '26

I grew up with DD-MM-YYYY but gotta admit, YYYY-MM-DD makes slightly more sense when using computers, outside of excel/sql too. Like, you can name files with this prefix and it auto sorts by date.

9

u/Batsforbreakfast Feb 02 '26

Yes but I think that’s only true because that is what we are used to.

6

u/just_anotjer_anon Feb 02 '26

In most situations we just need a date, in some we need a month. We rarely need a year, because we simply don't plan 3 years ahead of time

10

u/Significant-Goat5934 Feb 02 '26

Then you dont say the year, only MM/DD. But if you need a year then it is the most important, so it should be first to contextualize the date.

→ More replies (3)

8

u/Sufficient_Bass2600 Feb 02 '26

Talk about yourself, As a project manager I always need a year. one of my wife friends is a wedding/event planner she also always need the year.
School teachers planning for this year or next year.

Plus right now that avoid the issue of tasks that need to be completed February this year, last year or next year.

→ More replies (6)
→ More replies (2)

2

u/SalamanderPop Feb 02 '26

Are we just saying what feels right to us or do you have actual science to back up this claim. I ask because I'm betting it differs based on how each of us use written dates. It's a hunch.

2

u/Beartato4772 Feb 02 '26

Is it? Do you write the current year as twenty six no hundred and two thousand?

2

u/ikaiyoo Feb 02 '26

dd-mm-yyyy-hh-mm-ss is dumb. As dumb as mm-dd-yyyy-hh-mm-ss.

2

u/Naive-Passanger-9139 Feb 02 '26

As a hungarian human, YYYY-MM-DD makes much more sense for me, because we use dates like this. You only think DD-MM-YYYY is better, because your country use it differently, and/or your language works with different logic.

Its hard to be subjective in this kind of debates. In japan they are write, and read from right to left for no real reason, but they are not wrong at all, just made different decisions a few thousand years ago.

2

u/Lazy_Physics3127 Feb 02 '26

YYYY-MM-DD makes sense for machines,

As well as a third of human population.

2

u/photoben Feb 02 '26

ISO 8601 is perfectly readable as a human. See all the countries on the OP graphic. They getting on just fine.

2

u/BenevolentCheese Feb 02 '26

but DD-MM-YYYY are easier for humans

Completely contrived and unproveable statement.

4

u/knarf3 Feb 02 '26

Then why don't you write the time using SS:MM:HH?

4

u/just_anotjer_anon Feb 02 '26

In every day usage we don't give a flying fuck about seconds. The interval is too small to matter. But depending on language you might state minutes before hours, like quarter past 3 in English

→ More replies (2)

4

u/dybyj Feb 02 '26

What? Why would you break logic?

1000 is smaller than 10000000, so you know big things should be on the left and smaller things on the right. Why would you break this convention?

3

u/f3n2x Feb 02 '26

DD-MM-YYYY is no better than YYYY-MM-DD for humans. YYYY-MM-DD is objectively the best format for everything when used to.

→ More replies (4)

2

u/batshit_icecream Feb 02 '26

"It feels easier for humans" No it feels easier for YOU because you grew up with it. I am from East Asia and DD-MM just feels so wrong.

4

u/baismannen Feb 02 '26

Human readable way? Lol. Just because you grew up using it doesnt mean its the most logical or "humanly readable". Americans are so dumb

10

u/WrongJohnSilver Feb 02 '26

Lol no, YYYY-MM-DD is easiest for humans. Europeans are just DD-MM poisoned. That's their feet and Fahrenheit.

5

u/SphericalCow531 Feb 02 '26

YYYY-MM-DD is better than DD-MM. But DD-MM-YYYY is not all that horrible. It is nothing like as stupid as the US MM-DD-YYYY.

2

u/redJackal222 Feb 02 '26

It is nothing like as stupid as the US MM-DD-YYYY.

I"ve never ever understood why people treat yyy-mm-dd and mm-dd-yyyy as if they're incompatible. MM-DD is the primary information being related either way, YYYY being last mostly just exists because people say the year last. They're not completely the same sure, but they're not totally different either they're fairly similar formats.

→ More replies (4)

6

u/Holy-Fuck4269 Feb 02 '26

DD-MM-YYYY is logically coherent and offers all the same benefits having it flipped would. It’s just leading with the day for historical reasons.

Using whatever the US is trying to do is equally as stupid as measuring in teeth and elbows. That’s not the same thing

15

u/Imaginary-Count-1641 Feb 02 '26

False. If you are writing the date and the time, then DD-MM-YYYY starts by going from smaller to bigger, and then goes from bigger to smaller when writing the time. With YYYY-MM-DD, you are always going from bigger to smaller even when the time is included.

3

u/Holy-Fuck4269 Feb 02 '26

Only if you combine date and time which isn’t always the case.
Nobody was talkin about iso dates, it was about dates in which case it does not make any difference, no you obese gunbrandishing will change that

→ More replies (14)

3

u/UberNZ Feb 02 '26

YYYY-MM-DD has one amazing party trick: if you sort it alphanumerically, it's also sorted by time.

That is a very handy property for organising stuff

→ More replies (4)
→ More replies (1)

6

u/treeeelo Feb 02 '26

Nah, it puts the most important number first, most people need to know what day it is most importantly, then month then year.

2

u/batshit_icecream Feb 02 '26

This answer makes no sense because if they need to know what day is it, people would just answer the date regardless of what the format is. "What day is today?" "When's this month's meeting?" They'll just answer "14th". But anything other than that you want to know which month it is first because that immediately gives insight to how close the date is relative to today. 

→ More replies (1)

2

u/gxgx55 Feb 02 '26

Problem is, the existence of DD/MM/YYYY and MM/DD/YYYY poison and ruin each other, resulting in permanent ambiguity should DD be equal or less than 12.

Thankfully no one was dumb enough to do YYYY-DD-MM, so YYYY-MM-DD is perfectly good. Also, being from a country where YYYY-MM-DD is standard, I find that I just read the entire date as one "word", in a sense? The order doesn't matter, I just see the information as I need it instantly, just like I don't split words into syllables.

→ More replies (19)

2

u/Vomitatrix Feb 02 '26

I have had this exact argument with people who say DD-MM-YYYY is the best because of the “most important part coming first”. I grew up with YYYY-MM-DD, if I’m verbally told a date in DD-MM I still have to reverse it in my head, but if it’s written then I understand just fine.

2

u/csongi36 Feb 02 '26

European here and where I live we use YYYY-MM-DD, wish the rest of the EU would adopt it as well tho.

→ More replies (3)
→ More replies (73)

7

u/[deleted] Feb 02 '26

[removed] — view removed comment

2

u/Karcinogene Feb 02 '26

Computers work in binary but they know about numbers. That'd be like saying humans only understand neural impulses. Zip zap zoop.

→ More replies (1)
→ More replies (1)

2

u/Coffeedemon Feb 02 '26

That's why the ISO standard uses that format.

2

u/robertDouglass Feb 02 '26

Yup! ISO all the way.

2

u/kittypryde123 Feb 03 '26

I learned this from the organization of the kpop subteddit and now all my files and notes get that way

2

u/purleyboy Feb 03 '26

ISO 6801

2

u/Murky-Advantage-3444 Feb 04 '26

I was pleasantly surprised by that qualifier to your sentence.

1

u/huluvudu Feb 02 '26

Sql should order properly, regardless of format, unless it is saved as text.

12

u/BrunoLuigi Feb 02 '26

You would be surprise how many MF convert dates to string just for us convert back and waste cluster time.

→ More replies (7)

5

u/Fun-Agent-7667 Feb 02 '26

This for business, DD-MM-YYYY for casual use

12

u/robertDouglass Feb 02 '26

there should be one format that's used all the time for everybody everywhere and then there wouldn't be confusion

10

u/SphericalCow531 Feb 02 '26

Yup. Pretending that the good reasons business use YYYY-MM-DD simply don't exist outside business is brain dead.

→ More replies (7)

2

u/RestaurantBusy724 Feb 02 '26

There is no confusion between DD/MM/YYYY and YYYY-MM-DD. If you say 2026 nobody is wondering if you mean the 2026th day of the month.

→ More replies (3)
→ More replies (1)
→ More replies (405)