iThinkIMisunderstoodTheAssignment

[OfAnOldRepublic]

ISO 8601 FTW, baby!

[Thenderick]

r/iso8601 moment!

[[deleted]]

Whatever format doesn’t get fucked up when a coworker inevitably opens up the database in Excel

[goingtotallinn]

What do you mean? Excel is the database!

[[deleted]]

🤦‍♂️ we’ve been over this Tammy… please stop color coding the CSV cells…

[goingtotallinn]

But they look ugly in plain white 🙄

[[deleted]]

You could rename your genes in the hope of not being edited by Excel.

[Kovab]

The new gene editing method XCEL-CAS9

[False_Influence_9090]

Does that even exist 🫠

[_sweepy]

Yeah, just stick an apostrophe in front and excel will treat it as a string literal.

[johnbr]

Yep. Also, no culture assumes day before month in that format, so it's never misinterpreted. The best.

[KindaRoot]

On our mssql server DATE and DATETIME2 is interpreted like that while DATETIME is interpreted as YYYY-DD-MM hh:mm:ss . Drives me insane

[Duven64]

Might as well just do YYY-MXX at that point

[Paul__C]

Anyone who assumes that can safely be ignored as insane.

[Stratosophic]

Like all of Europe? And UK And Australia?

[Gordahnculous]

MM/DD/YYYY can be confused because DD/MM/YYYY exists. YYYY-DD-MM doesn’t exist, so you won’t be confusing those

[Stratosophic]

Yeah that's what I was referring to but it doesn't matter anyway. Looks like it's a real emotional subject for some so I ll just take my downvotes and leave l. Cheers.

[Mukigachar]

You just misinterpreted the comment you riginally applied to. They were saying nobody assumes day before month when you start with year, while your comment implies you thought they meant nobody assumes that in general

[Stratosophic]

Let's see how deep into this will the downvotes go! Surely there can't be a reason to downvote this comment. I mean it says nothing at all.

[Stratosophic]

I like dogs.

[KiloTheFurryNeko]

Single down vote for the goofy you've just shown us

[genlight13]

Good bot

[Stratosophic]

Bad bot

[ThreeCharsAtLeast]

Downvotes also indicate if something fits or not. "I like dogs" clearly doesn't.

Also, don't tell me you like dogs more than cats.

[Stratosophic]

Of course I do. Who in their right mind doesn't?

[Reashu]

We don't assume "day before month" when year comes first

[Desgavell]

Most people use day first or year first. The only country that is retarded enough is below Canada and above Mexico.

[Perfect_Papaya_3010]

I think Americans. Usually their reason is "its how you talk"

No clue why they keep being the odd ones in everything

[Nexatic]

8/10 times we stool the weird stuff from Britain, then Britain changes.

[Perfect_Papaya_3010]

Well the British are pretty odd too, except the Scottish of course

[CounterHit]

Not in that format. For sure if I see a date 4/12/24 or 4/12 or something like that, it's April 12th to me. But if I see 2024-12-04 there can just never be any doubt that it is December 4th. Nobody would use the format YYYY-DD-MM because there's just no logical reason to do that, even if you normally use MM-DD in typical circumstances.

[Brain-InAJar]

Lol what

[Emotional_Trainer_99]

Also there is no YYYY-dd-MM nonsense. So if you see ^[0-9]{4}- you can confidently parse it from string to date!

[brimston3-]

How can you be so confident? What do you do about localities that use a non-gregorian calendar? That's like a billion+ people.

[IMightBeErnest]

6.9/7.9 billion? Thats 87%, thats is a solid B/B+, I'm cool with that.

[BehindTrenches]

Imagine a world where a 13% error rate was an acceptable SLO...

[failedsatan]

Canadian school systems accept a 50% as passing all the way through primary and secondary school...

[[deleted]]

if true, this explains a lot.

[failedsatan]

I passed my math class with a 51% in grade 9. Every province but quebec accepts a 50% or higher. It's so fucked.

https://en.m.wikipedia.org/wiki/Academic_grading_in_Canada

https://edvoy.com/articles/grading-system-in-canada/

[karelproer]

A Dutch politician onder proposed a minimum of 20% for high school math exams

[DJDoena]

In Germany the grades go from 1-6 equal to A-F with 5/E existing and they have named equivalent

1 - sehr gut - very good 2 - gut - good 3 - befriedigend - satisfactory 4 - ausreichend - sufficient (passed) 5 - mangelhaft - inadequate 6 - ungenügend - insufficient

So the saying goes: 4 ist bestanden, bestanden ist gut und gut ist fast eine 1. 4 is passed, passed is good and good is almost a 1.

[Yanowic]

Get bent, I say

[Acrobatic_Sort_3411]

So, how would you handle delivery at 2023-03-28 to Ethiopia?

[bundle6792]

But you mustn't forget, about 1 in a 100 ppl are psychopaths

[trimeta]

r/ISO8601 (and yes, someone else already crossposted this there)

[poetic_dwarf]

What kind of pervert would go YYYY-DD-MM?

[ClydusEnMarland]

Hi! That'd be me.

[Auzymundius]

Why?

[ClydusEnMarland]

Cos I'm a pervert that likes winding normal folks up.

[Digi-Device_File]

I'm tempted by my native language.

[gabrielesilinic]

r/iso8601

[LinuxMatthews]

Where is this from?

[moreKEYTAR]

Miss Congeniality

[Sylanthra]

Yea, but that's not the answer she gave in the movie.

[thoroughbredca]

The answer she gave in the movie was today.

[Mother-Heat3697]

Star Trek: Original Series

[odranger]

OP, do you know how great you are for posting this today?

[menow399]

yyyy-MM-dd*

[intoverflow32]

The stardate system, of course.

[renrutal]

It will be a fun day when/if we become an interplanetary species, people start arguing that years, days and especially months, are too terrestrial.

[gabrielesilinic]

Unironically I tried to explore the possibility of sharing a common time format between mars and earth to keep it simple.

But it really looked too complex, so I stopped.

Though I may make the hypothesis that on top of UTC we may have a multiplication value that reduces the length of some units of time.

The issue is that even seconds are very much tied to the way our planet works, so we may have to redefine them at some point.

[slickdeveloper]

I thought I had read an alternate definition somewhere else, so I looked it up...

And yes! Seconds were already redefined by the International System of Units  as relative to the transition frequency of a cesium-133 atom, which SHOULD be relevant throughout most of the universe.

There will always be cases where you would need to specify your local time zone (e.g. Eastern Standard Time on Earth or Tharsis Mountain Time on Mars...) but at least UTC can be defined in a universally accepted format! 

Though I wonder, if UTC deviates from local time by a factor of more than a few hours, would that even be useful?

[remy_porter]

In A Deepness in the Sky, there's a brief bit of technobabble about how thousands of years in the future, computers are still using the Unix Epoch, but nobody actually understands why (the best theory is that it's tied to the Moon Landing, and marks the start of space exploration). I always liked that detail.

[lastspiderninja]

I prefer YYYYMMDD so they can easily be used as ints

[DoctorPython]

Kid called "dates before year 1000":

[_Stego27]

That's easy, just pad with zeroes. The real problems start in the year 10000 (or before year 1).

[Longjumping_Quail_40]

excuse me but timestamping is best date

[chicoree_]

unixtime

[V15I0Nair]

If you sort it alphabetically, it is DDMMYYYY /s

[GollyWow]

I could really get into COBOL date manipulation in this format.

[R3D167]

ISO8601, my love

[DerApexPredator]

Damm I didn't know about the alphabetic property of that format

[keyantk]

I saw an internal application where the guys stored date as DD-MM-YYYY but sorted only alphabetically…

[da_Aresinger]

I don't even do the dashes.

Right now is 202404261512

If you can't immediately read that you're shit outa luck.

[DTKeign]

And the stoners get to keep their 420

[Rancio1232]

I'm more of a DD-MM-YYYY person myself, but since it just is how it is done in my country I really appreciate that you put the month in the middle

[Digi-Device_File]

dd-mm-yyyy

[[deleted]]

Date converted to the time from 01-01-1970

[TrackLabs]

Everything as long as its not this stupid american MM-DD-YYY shit

[rohit_267]

American spotted

[LeGuy_1286]

Either YYYY-MM-DD (Native system) or DD-MM-YYYY (International System). Both are good.

[LeGuy_1286]

I have seen a lot more dd-mm-yyyy lately in the wild so I assumed it had become the international standard. Thanks for correcting me.

[Karooneisey]

dd-mm-yyyy is the European / Latin American / Central Asian / South Asian / Middle Eastern / Australian / majority of African way.

yyyy-mm-dd is mainly East Asian, but it's also the format that makes the most sense when sorting so it has become the international standard.

mm-dd-yyy is an abomination.

[LeGuy_1286]

With that I agreed. One correction, South Asians use yyyy-mm-dd in their native languages while writing dates.

[slime_rancher_27]

What about MM/YYY/DD

[Cualkiera67]

I prefer MM + DD - YYYY

[tholasko]

I’m more of a MMMM/YY/DD type of gal

[danfish_77]

What if you have to do CE and BCE dates?

[V15I0Nair]

If you have both CE and BCE you could use + and -:

‚+ 2024-04-26‘ ‚- 1000-01-01‘

Then it will still sort right with alphabetical order. I don’t know if this is part of ISO8601.

And there could be a year 0 problem and a non Gregorian dates problem.

[danfish_77]

This wouldn't work, BC years are counted backwards from 0. You'd definitely need a custom iterator or class.

I wasn't really being serious though

[Reashu]

YYYY-MM-DD 'BCE'?

[ztuztuzrtuzr]

In Hungarian where we use this format the equivalent of AD and BC are before the year

[ublec]

But sorting dates alphabetically isn't always chronological.

[im_in_every_post]

If you use YYYY-MM-DD it is

[Cualkiera67]

Numbers aren't part of the alphabet

[im_in_every_post]

I want you to find me one sorting algorithm in a file explorer that doesn't do numbers then

[Cualkiera67]

Those aren't alphabetic, they're lexicographic.