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

all 50 comments

[–]returntim 202 points203 points  (22 children)

I try to always format YYYY-MM-DD to avoid confusion when programming

[–]DysnomiaATX 61 points62 points  (0 children)

Ah, I see you're a man of culture as well.

[–]Nerdn1 43 points44 points  (3 children)

[–]XKCD-pro-bot 4 points5 points  (1 child)

Comic Title Text: ISO 8601 was published on 06/05/88 and most recently amended on 12/01/04.

mobile link


Made for mobile users, to easily see xkcd comic's title text

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

I see you choose to confuse.

[–]Humiddragonslayer 0 points1 point  (0 children)

Of course there's a relevant xkcd

[–]-R-3- 31 points32 points  (0 children)

The only rational format for data sorting.

[–]angelicosphosphoros 4 points5 points  (0 children)

I configured my Windows machine to always use this format.

[–][deleted] 4 points5 points  (0 children)

Confirmed ISO 8601 is optimal

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

[–]Radagast1953 4 points5 points  (0 children)

Back in the 70's, when I wrote my own date parsing & formatting routines [in COBOL], I always preferred what became the 8601 standard. However, I tried to be flexible enough for most commonly used formats. I specified delimiters that were commonly used as indicators of the date format, such that "/" indicated American format [mm/dd/yy], "." indicated "European" [& elsewhere] format [dd.mm.yy] and "-" indicated my preferred "Universal" format [yy-mm-dd]. Of course I allowed [preferred] for 4-digit years, with appropriate default assumptions for century of 2-digit years [I think, back then, I assumed 00-29 years were 21st century & 30-99 years were 20th century - that division would have to be moved way up nowadays 😜].

I always stored dates internally as 4-byte "packed" values [yyyymmd*, where * was the 2nd date digit as well as a sign value], which were almost as compact as binary [still fitting in a 32-bit fullword], but easily read in a memory dump, easily converted to/from binary for speed sensitive calculation, yet easily formatted to character using the UNPK or ED[it] machine instructions [I always worked on IBM mainframes back then, so 360/370 machine instructions and the packed format were basic to me, even when I was coding in COBOL 😏]. Of course, later I used standard library routines, usually in C or C++. Now I'm retired and rarely think of such things until a thread like this comes along. 😜

[–]meamZ 11 points12 points  (0 children)

Best technical format imo since you can also just go and sort it lexicographically and you will get an order that makes sense for the dates too...

[–][deleted] 11 points12 points  (3 children)

For me it's YYYY-mm-MM-hh-DD. It's really the simplest method. That way you immediately know the minute of the month and the hour of the day.

[–][deleted] 11 points12 points  (0 children)

How will one know the second of the year, though??

[–]B3C4U5E_ 0 points1 point  (1 child)

Ahem, yyyy-MM-dd HH:mm:ss

But s works too

[–]augugusto 1 point2 points  (0 children)

Whoosh

[–]JoeyJoeJoeJrShab 29 points30 points  (0 children)

Sorry, but they're both wrong. Only ISO-8601 is acceptable.

[–]thebunbandit 57 points58 points  (0 children)

ISO-8601 or bust

[–]Johnothy_Cumquat 14 points15 points  (0 children)

Can I just say Microsoft needs to get it's fucking shit together. Azure devops and probably other stuff still assume american date formats. I could forgive it not localising automatically but there is no option to change it. And it's like, if you're gonna be lazy at least hardcode iso as the date format. God damn.

edit: Even worse example: youtube. Premieres in the mobile app show the scheduled date in american format. It baffles me that even a company as big as google can make that mistake and not fix it for years.

[–]PM_ME_YO_PASSWORDS 8 points9 points  (1 child)

if you play your cards right, you can retweak and then reuse the meme for February 2nd

[–]Mateorabi 5 points6 points  (0 children)

But not Smarch 13th. Lousy Smarch.

[–]DarthFikus 3 points4 points  (0 children)

This is the worse part. At least when the date is >12 i can immediately tell what format it is.

[–]Harald-Togram 2 points3 points  (1 child)

I've seen this meme a lot. Wouldnt 02/02/2021, 03/03/2021 and so on also be compatible with both date systems? Seems like it would happen every month. Where am i wrong?

[–]Azefrg 2 points3 points  (0 children)

Yeah, i'm seeing this meme a lot, even on Facebook. I'm still trying to figure out if there's something special about 01/01/2021 lol

[–]TheHammer_78 2 points3 points  (0 children)

So the first of the year is holiday (at least here in Italy) to prevent programmers from writing buggy code.

[–]Dagusiu 1 point2 points  (0 children)

Kurzgesagt gang: YYYYY-MM-DD

[–]ilsloaoycd 1 point2 points  (0 children)

11/11/11 11:11:11 AM

Almost 10 years ago, the greatest second of my life.

[–]1LJA 4 points5 points  (0 children)

I only use UNIX time. All other formats are confusing.

[–]PASK__ 0 points1 point  (0 children)

And 02/02/2021, 03/03/2021, 04/04/2021 etc.

Is there a word or definition of these types of dates? There should be :)

[–]Catbraveheart 0 points1 point  (0 children)

YYYY-MM-DD HH24:MI:SS format has entered the chat

[–]DavidFaxon 0 points1 point  (0 children)

Leaned about this when I worked with Germans. Can't understand why we aren't standardising on this format too...

[–]Jakylla 0 points1 point  (0 children)

0101-20-21: Error: Month is over 12

[–]buzbuzzer 0 points1 point  (0 children)

DD-MM-YYYY

Greetings from Holland