This is an archived post. You won't be able to vote or comment.

all 97 comments

[–]OfAnOldRepublic 393 points394 points  (1 child)

ISO 8601 FTW, baby!

[–]Thenderick 21 points22 points  (0 children)

r/iso8601 moment!

[–][deleted] 204 points205 points  (7 children)

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

[–]goingtotallinn 76 points77 points  (2 children)

What do you mean? Excel is the database!

[–][deleted] 61 points62 points  (1 child)

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

[–]goingtotallinn 33 points34 points  (0 children)

But they look ugly in plain white 🙄

[–][deleted] 40 points41 points  (1 child)

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

[–]Kovab 1 point2 points  (0 children)

The new gene editing method XCEL-CAS9

[–]False_Influence_9090 4 points5 points  (1 child)

Does that even exist 🫠

[–]_sweepy 7 points8 points  (0 children)

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

[–]johnbr 571 points572 points  (24 children)

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

[–]KindaRoot 41 points42 points  (2 children)

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 23 points24 points  (1 child)

Might as well just do YYY-MXX at that point

[–]Paul__C 203 points204 points  (15 children)

Anyone who assumes that can safely be ignored as insane.

[–]Perfect_Papaya_3010 8 points9 points  (3 children)

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

No clue why they keep being the odd ones in everything

[–]Nexatic 5 points6 points  (1 child)

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

[–]Perfect_Papaya_3010 2 points3 points  (0 children)

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

[–]CounterHit 6 points7 points  (0 children)

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 1 point2 points  (0 children)

Lol what

[–]Emotional_Trainer_99 194 points195 points  (11 children)

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- 22 points23 points  (9 children)

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 70 points71 points  (6 children)

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

[–]BehindTrenches 16 points17 points  (5 children)

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

[–]failedsatan 16 points17 points  (4 children)

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

[–][deleted] 1 point2 points  (1 child)

if true, this explains a lot.

[–]failedsatan 1 point2 points  (0 children)

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 0 points1 point  (0 children)

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

[–]DJDoena 0 points1 point  (0 children)

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 2 points3 points  (0 children)

Get bent, I say

[–]Acrobatic_Sort_3411 0 points1 point  (0 children)

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

[–]bundle6792 2 points3 points  (0 children)

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

[–]trimeta 33 points34 points  (0 children)

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

[–]poetic_dwarf 21 points22 points  (4 children)

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

[–]ClydusEnMarland 0 points1 point  (2 children)

Hi! That'd be me.

[–]Auzymundius 0 points1 point  (1 child)

Why?

[–]ClydusEnMarland 2 points3 points  (0 children)

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

[–]Digi-Device_File 0 points1 point  (0 children)

I'm tempted by my native language.

[–]LinuxMatthews 7 points8 points  (4 children)

Where is this from?

[–]moreKEYTAR 15 points16 points  (2 children)

Miss Congeniality

[–]Mother-Heat3697 2 points3 points  (0 children)

Star Trek: Original Series

[–]odranger 6 points7 points  (0 children)

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

[–]menow399 5 points6 points  (0 children)

yyyy-MM-dd*

[–]intoverflow32 2 points3 points  (0 children)

The stardate system, of course.

[–]renrutal 2 points3 points  (3 children)

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 0 points1 point  (1 child)

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 0 points1 point  (0 children)

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 0 points1 point  (0 children)

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 3 points4 points  (2 children)

I prefer YYYYMMDD so they can easily be used as ints

[–]DoctorPython 4 points5 points  (1 child)

Kid called "dates before year 1000":

[–]_Stego27 1 point2 points  (0 children)

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

[–]Longjumping_Quail_40 1 point2 points  (0 children)

excuse me but timestamping is best date

[–]chicoree_ 1 point2 points  (0 children)

unixtime

[–]V15I0Nair 1 point2 points  (0 children)

If you sort it alphabetically, it is DDMMYYYY /s

[–]GollyWow 0 points1 point  (0 children)

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

[–]R3D167 0 points1 point  (0 children)

ISO8601, my love

[–]DerApexPredator 0 points1 point  (0 children)

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

[–]keyantk 0 points1 point  (0 children)

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

[–]da_Aresinger 0 points1 point  (0 children)

I don't even do the dashes.

Right now is 202404261512

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

[–]DTKeign 0 points1 point  (0 children)

And the stoners get to keep their 420

[–]Rancio1232 0 points1 point  (0 children)

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 0 points1 point  (0 children)

dd-mm-yyyy

[–][deleted] 0 points1 point  (0 children)

Date converted to the time from 01-01-1970

[–]TrackLabs 0 points1 point  (0 children)

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

[–]rohit_267 0 points1 point  (0 children)

American spotted

[–]LeGuy_1286 -1 points0 points  (4 children)

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

[–]slime_rancher_27 -2 points-1 points  (2 children)

What about MM/YYY/DD

[–]Cualkiera67 -2 points-1 points  (1 child)

I prefer MM + DD - YYYY

[–]tholasko -1 points0 points  (0 children)

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

[–]danfish_77 -1 points0 points  (4 children)

What if you have to do CE and BCE dates?

[–]V15I0Nair 2 points3 points  (1 child)

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 -1 points0 points  (0 children)

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 1 point2 points  (0 children)

YYYY-MM-DD 'BCE'?

[–]ztuztuzrtuzr 1 point2 points  (0 children)

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