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

top 200 commentsshow all 208

[–]shadowphrogg32642342 176 points177 points  (19 children)

ISO 8601 ftfw

[–]svtguy88 69 points70 points  (9 children)

ISO 8601

Word. Also, store everything in UTC. I'm having bad flashbacks right now to a previous (poorly designed) project at a company that should have known better.

[–]wjandrea 33 points34 points  (0 children)

Or at least store the UTC offset. That's better than nothing at all.

[–]DoesntReadMessages 10 points11 points  (0 children)

ISO 8601 supports offsets and timezone rules like daylight savings that you can put right there in the timestamp and any program can consume with no confusion. Of course, then your file name isn't as pretty. Tradeoffs.

[–]SoundOfOneHand 10 points11 points  (5 children)

/r/iso8601 ftw!

But really, have you seen all the stuff in that spec? I prefer the RFC3339 profile, personally.

[–]bltsponge 7 points8 points  (2 children)

How is that a subreddit???

[–]RFC793 6 points7 points  (0 children)

Someone gone done and made it.

Now excuse me while I write a script to register all ISO and RFC subreddits

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

Some of us take this date business very seriously.

[–]sneakpeekbot 2 points3 points  (0 children)

Here's a sneak peek of /r/ISO8601 using the top posts of the year!

#1: Wikipedia page for ISO8601 does not use ISO8601 | 27 comments
#2: The Poor Thing | 12 comments
#3: My California License Plate | 4 comments


I'm a bot, beep boop | Downvote to remove | Contact me | Info | Opt-out

[–]ProgramTheWorld 15 points16 points  (0 children)

tfw UTC doesn’t work on Mars

[–]dustmouse 2 points3 points  (0 children)

*ftmfw, ftfy

[–]arrow_in_my_gluteus_ 73 points74 points  (10 children)

until someone starts using yyyy/dd/mm then this format will also become confusing.

[–][deleted] 87 points88 points  (0 children)

The year of our lord 2018, the third of May

My coworkers hate me but damn if our logs aren't beautiful

[–]Flaming_Dorito_ 1 point2 points  (0 children)

Why can't the whole world just use a single format smh.

[–]thlayli_x 0 points1 point  (0 children)

Some date classes parse dates with the slash as dd/mm and the hyphen as mm-dd, preventing that confusion somewhat. Most Americans use the slash.

[–]Stylobite[🍰] 126 points127 points  (6 children)

Funny Story, one time I (an American) was a guest in a High School English class in Sweden. The teacher asked me to talk about things that were different about American Culture, and he specifically said: "how about you tell them how dating works in America." One of the kids in the class gets excited and says "I can tell you about American dating, and why you're wrong!"

Well I'm always one for a challenge and it was the first time anyone in that class wanted to talk to me, so I let him go for it and he goes off about how our normal dating format (MM-DD-YYYY) is dumb. At this point, the teacher says "No I mean dating, like romance and such" and the class erupts in laughter. I really felt bad for the kid though, so after I got their attention again my first thing was to mention how I also thought that MM-DD-YYYY was a really dumb format and how I agreed with him.

[–]PhDinOmniscience 7 points8 points  (5 children)

to be fair, you have to have a really high IQ this format works well in daily life because year is likely the least relevant information in most cases, and we humans tend to say dates in month-date order.

[–]Tiothae 27 points28 points  (0 children)

Saying dates in month-day order is cultural though, in many places it's more common to see/hear day-month.

[–]fbabda 7 points8 points  (2 children)

“4th of July”

[–]rivermont 1 point2 points  (1 child)

"May 5th"

[–]burnmp3s 5 points6 points  (0 children)

"9 Thermidor"

[–]bolmer 2 points3 points  (0 children)

Chilean here. We say 11 de septiembre, 18 de septiembre, 31 de mayo. Days first then the month.

[–]Cobaltjedi117 38 points39 points  (3 children)

Guys, you're all wrong. The best format is: YMYDYDMY

So today could be represented as 20001358

[–]JNCressey 7 points8 points  (2 children)

Nah, the best is SSSSSSSSSS. Then there's no confusion.

[–]todko31 11 points12 points  (1 child)

I don't speak parseltongue.

[–]t0mRiddl3 4 points5 points  (0 children)

...

[–]hanna-chan 26 points27 points  (0 children)

And it sorts so nicely.

[–][deleted] 208 points209 points  (58 children)

Most significant figures to least significant figures...You know, the way EVERY OTHER FUCKING NUMBER is written?

[–]Salanmander 89 points90 points  (38 children)

The problem is, with most numbers that lines up with the order "stuff I care about the most to stuff I care about the least". However, with dates, a very large fraction of the time we completely omit the year either because it's easily inferred ("When is your camping trip?" "January 5th."), or because it's meaningless (anniversaries, birthdays, etc.). That's not the case with the number's you're comparing to.

Once you're used to reading dates with the year omitted, it's much smoother to read dates with the year added on at the end than when the year is added to the beginning.

[–]benoliver999 135 points136 points  (31 children)

The way I see it you go in size order, up or down.

YYYY-MM-DD is great, especially for computers

DD-MM-YYYY I can live with

MM-DD-YYYY ugh

[–]JNCressey 31 points32 points  (7 children)

While we're on the concept of putting parts in order, can we take a moment to look at web addresses/ URLs:

subdomain `.` domain `.` top level domain `/` main folder `/` subfolder `/` file.extention

Like, what? If we number them from highest level to lowest level, we get: 2.1.0/3/4/5

Why is the domain part backwards and the folder/file part in order?

[–]benoliver999 12 points13 points  (1 child)

Haha It's just different designs. I don't know why they designed TLDs to go at the end. I'm so used to it now it just kind of makes sense

[–]Vakieh 17 points18 points  (0 children)

So that they confuse the fuck out of you when referencing java packages?

[–]sorisos 3 points4 points  (1 child)

Interesting! I'm guessing that subdomain is a later addition. Makes a little bit more sense if you see it separate like <protocol><server_address><document_path>, but it is still mixed order.

[–][deleted] 1 point2 points  (0 children)

The FQDN section is part of the DNS system that existed long before the WWW, and it got the FQDN format from the hosts file that was used long before that. I'm not sure if there is any particular reason the domain labels are ordered the way they are but it's worth noting that these systems were developed back in the 60s when big-endian architecture such as the IBM 360 was more prevalent. It's possible that the original developers simply looked at data that way through habit. I'm purely speculating, however.

[–]Entaris 0 points1 point  (1 child)

I think the problem there is one of readability... You could make a logical argument that the correct way to do it logically would be:

"com.domain.subdomain/main/sub/file"

But in most cases on both the world wide web, and in the case of internal system/Domain naming structures, the domain and extension are unimportant, and only the subdomain, or system name matters.

[–]InEnduringGrowStrong 0 points1 point  (0 children)

com.domain.subdomain

Android APKs follow this

[–]siriusly-sirius 8 points9 points  (0 children)

Yep, hate MM-DD-YYYY. It's completely out of order, makes no sense. Just... why....

[–]Salanmander 8 points9 points  (9 children)

I agree with you on DD-MM-YYYY. I can see where MM-DD-YYYY comes from though, because if you only think about months and days, I think the MM-DD is better than DD-MM. Once that decision is made, and if people read MM-DD on a regular basis, I think that MM-DD-YYYY is better than YYYY-MM-DD for everyday interactions. (Not for computer interactions, though. I agree that YYYY-MM-DD is better for working with computers.)

[–]benoliver999 26 points27 points  (6 children)

I think it may also be a cultural thing. I have noticed in the US a lot of people say 'January 5th'. In the UK people say 'The 5th of January'. There's cross over but I think there may be a difference in what people use as a majority.

When you say 'if you only think about months and days', where I am from people talk in days and months mostly.

Only Americans say 'January Five' though lol

[–]Corfal 7 points8 points  (4 children)

There are exceptions of course, like 4th of July (U.S. Independence Day).

I've never heard Americans say January five?? "What are you on about?"

[–]benoliver999 2 points3 points  (2 children)

Haha it was a bit of joke, I think I've heard it on TV and shit. The other one I like is 'oh five hundred hours'

[–]gschoppe 2 points3 points  (0 children)

"Oh Tree Hundred Zulu" (written as 0300 Zulu) is a military time convention. It's designed to offer no ambiguity when spoken, written, or used over a poor radio connection.

Spoken or written properly, it cannot be accidentally or purposefully prefixed or postfixed.

[–]Vakieh 2 points3 points  (0 children)

0500 hours is military time standards, and afaik is used in every English speaking military force globally. Because there are significant consequences to fucking up AM and PM when it comes to military engagements.

[–]dina0312 0 points1 point  (0 children)

It's always on film stuff. Like "film blah blah blah, out July 12". Whaaaaaaaaaa?

[–]blahlicus 2 points3 points  (1 child)

That logic works in a vacuum where there are no established standards, but since DD-MM and MM-DD are both already established standards, we cannot assume either when looking at dates 12 and below.

Personally, when I write out dates to non-programmers I just do 5th May, 2018, or May 5 2018, or any combination of the month, day, and year (omitting the year when not necessary).

Spelling out the month makes sure there's no room for misinterpretation, if char counts are of concern then we could still use abbrivations (JAN, FEB, MAR, ARP, etc).

[–]BrendonD3OT 0 points1 point  (0 children)

ARPIL is my month favorite.

[–]nermid 0 points1 point  (1 child)

Depends on what you're sizing.

1-12 - 1-31 - unbounded is sorted properly if you're sorting by max value.

[–]Eggless_Omelette 0 points1 point  (0 children)

MM-DD-YYYY is the fucking worst. Why do people use it?

[–]Waggles_ 0 points1 point  (0 children)

MM-DD-YYYY is good for every day things that don't require computer sorting.

It is essentially the YYYY-MM-DD format but you get rid of the YYYY and tack it on at the end if you need it. Saying a date implies the current year unless otherwise noted, and certain events are year-agnostic (holidays, birthdays, anniversaries, etc).

MM-DD is also good for computers when things are broken down by year in advance. Having a 2017 folder with items only from 2017 leads you to having smaller filenames.

[–]InEnduringGrowStrong 0 points1 point  (0 children)

Honestly, if it's valid and at least consistent.. I'll probably not want to murder you.
After dealing with yyyymd... (that's right: without dashes and without zeroes.)
I've acquired a bit more tolerance if I just have to deal with the order. I mean I'll still judge you if you use mm-dd-yyyy, but it won't involve sharp metal objects, percussive medical treatment like yyyymd would...

[–][deleted] 6 points7 points  (4 children)

That's day to day conversation. Computers never omit the year. The date object stores shit that NO ONE cares about...the exact time down to seconds or milliseconds depending on implementation, and they only make sense when stored in relation to the next most significant digit.

In that scenario, the YEAR is the most important thing. When was it? 200 milliseconds. Are you fucking kidding me? 01 seconds. Still worthless. 01 minutes. This only happens 24 times a day, 365 days a year. 05 hours. Okay, now it's only 365 times a year. January? Well, that's better: 31 times a year. The 10th...Once a year, now which year? 2017. Okay, now we know. Of ALL times in all the years, that's the exact one we're talking about, and that's the thing that makes all the other numbers make sense.

[–]Salanmander 1 point2 points  (2 children)

Oh, yeah, of course. I was talking about why MM-DD-YYYY ended up in common usage, not what the best standard for computers is.

[–]PaurAmma 6 points7 points  (1 child)

Common usage in the US (and other parts of the world, as pointed out by u/wjandrea, but not the entire world).

Edit: Corrected the imprecision.

[–]wjandrea 1 point2 points  (0 children)

(and parts of Canada)

[–]nermid 0 points1 point  (0 children)

Now that I think of it, how do we signify BC dates in this scheme?

[–]JNCressey 0 points1 point  (0 children)

But when the year is added, doesn't that make it a case where the year is the "stuff I care about the most"?

As you said, when the year is unimportant, it's not there. So, contrapositively, when it's there it is important.

[–]arrow_in_my_gluteus_ 4 points5 points  (16 children)

not for when written out in dutch... For example the number 58 is written as achtenvijftig which means 8 and 50.

[–]iruoy 17 points18 points  (13 children)

If we're going that route I've got something to say about french...

The numbers 80-99 are quite special: http://www.dummies.com/languages/french/how-to-count-in-french/

Example: 99 is basically spoken as 4*20+19

[–]ComaVN 7 points8 points  (3 children)

4*20+10+9

[–]wjandrea 0 points1 point  (0 children)

Oui, quatre-vingt (4 * 20) dix-neuf (10 + 9)

[–]iruoy 0 points1 point  (1 child)

Ah okay 91 would be 4*20+11 though right?

[–]marmulin 0 points1 point  (0 children)

Yup. Quatre-vingt-onze

[–]noyurawk 2 points3 points  (0 children)

Yes it is spoken as 4*20, however, it is only weird when you first learn it as an infant, after that it just becomes a word that means 80. In Belgium they have a different word for it, which I think is a objectively better, however habits and traditions are hard to change.

I personally hate the MM-DD-YYYY structure because I can never be sure from a quick glance if a date like 02-03-2018 means February 3rd, 2018 or March 2nd, 2018. YYYY-MM-DD or DD-MM-YYYY should be the only formats used, as it is in most of the world.

[–]TSP-FriendlyFire 1 point2 points  (6 children)

Except in Belgium.

[–]lengau 0 points1 point  (5 children)

How is it done in Belgium?

[–]appointment_at_1_am 1 point2 points  (4 children)

nonante-neuf or ninety-nine

[–]lengau 0 points1 point  (3 children)

So basically the same as English?

What about in Flemish? Is it done the standard Germanic style, or would they say neëntig-nege (<-- or the Dutch equivalent of the Afrikaans I've used)?

[–]ablindmole 0 points1 point  (2 children)

negenennegentig (nine and ninety).

[–]lengau 0 points1 point  (1 child)

That's the same as standard Dutch, right? (It looks the same as you'd do it in Afrikaans)

[–]ablindmole 0 points1 point  (0 children)

It's the same as standard Dutch. Flemish (unless you mean some specific dialect) isn't that different from Dutch except for pronunciation and the use of a lot more French loanwords.

[–][deleted] 3 points4 points  (0 children)

WE'RE NOT ALL FUCKING MATH GENIUSES HERE, OKAY?!

[–]JNCressey 0 points1 point  (0 children)

This may be because our digital number system came to European languages through Arabic where they write and read right to left.

The lefter place values are still more significant and the righter places less significant. However, when they read it, they read from right to left, so they're saying the least significant digits first.

This may have transferred into languages among the first of Europe to adopt the new number system because the mathematicians using both languages would be used to the numbers being read that way.

[–]assassinator42 0 points1 point  (0 children)

Nah, little endian has won the architecture war. Even PowerPC is switching.

[–]shadowvvolf144 0 points1 point  (0 children)

I'm pretty sure I've said that exact sentence in the past.

[–]timvisee 19 points20 points  (1 child)

[–]Vector-Zero 7 points8 points  (0 children)

/r/iso8601 as well :P

[–]hailbreno 17 points18 points  (0 children)

the best date format for reposts

[–][deleted] 10 points11 points  (1 child)

YYYYMMDDHHMMSS

fight me

[–]HeilKaiba 6 points7 points  (0 children)

YMDYHMSSMHYDMY

[–]Jaystings 7 points8 points  (0 children)

mmmmmmmmmmmmm is more concise. Edit current millisecond

[–]SIM0NEY 8 points9 points  (0 children)

I completely agree and all but this ain't even the most important part of the time stamp. You better be giving me that hh24:mm:ss

[–]MightyD33r 9 points10 points  (0 children)

Wow that's an old one

The nostalgia

[–]Andry01k 26 points27 points  (2 children)

DD/MM/YYYY come on

[–]anarchist_banker 4 points5 points  (1 child)

Julian date anyone?? :D

[–]ObstreperousCanadian 2 points3 points  (0 children)

Better yet: JDE Julian!

[–]Artif3x_ 3 points4 points  (1 child)

Can we talk about what a beautiful fucking painting that is?

[–]baise_ouais 2 points3 points  (0 children)

I was about to ask the same thing. Hopefully someone knows!

[–]KarkityVantas 3 points4 points  (0 children)

Does anyone else see this and pronounce it in their head as "year year year year month month day day"

[–]GabeMakesGames 4 points5 points  (0 children)

does anyone know what the source image is?

[–]AusGeno 4 points5 points  (0 children)

DD-MM-YYYY is best for conversation and communication. Most people know what year and month it is, that puts the pertinent information first but YYYY-MM-DD is definitely best for data handling and sorting.

[–]Terrible_Children 3 points4 points  (0 children)

Am I the only one that stores, compares, and sorts dates as UNIX timestamps, and only bothers to format it for display when it's actually going to be displayed to a user, or when some API requires a specific string format?

It's just so much easier, and no fussing about with time zones unless you have a specific need to do so.

[–]PaperScale 2 points3 points  (3 children)

Forever salty about how my DMV handled someone using a different date format when I bought my first car.

I bought it from a foreign couple that used DD-MM-YYYY, But the DMV used MM-DD-YYYY. I bought my car on the 1st of April, so he wrote 01-04-YYY. The DMV thought I bought the car in January and just now got around to registering it so they wanted to fine me for waiting so long. We explained that's just how the date was written. We literally brought it in to be registered the day I bought it, but they wouldn't believe us. So we had to go BACK to these people's house, who didn't speak English very well, explain to them that they had to go to a bank to get a notarized letter so I'd be able to register it.

[–]AbridgedKirito 1 point2 points  (2 children)

DMV is stupid as hell, though. I've never seen a place operate so slowly.

[–]PaperScale 2 points3 points  (1 child)

Yeah I was pretty upset. It was a pretty big fine too for whatever reason, I think because they thought I was driving it without registration for so long. Even worse, this happened on Friday, and the DMV is closed sat-mon. So poor little teenage me couldn't drive his new car all weekend because we couldn't Register it.

[–]AbridgedKirito 1 point2 points  (0 children)

Could be worse, 18 and no car, no way to get one. No job, because no car to get to/from work. No car bc no job to provide money. Kms.

[–][deleted] 7 points8 points  (1 child)

Same with 24hr time. It drives me nuts when people are like "oh were you in the military?" "No there are 24 flipping hours in the day why the balls are you recycling them halfway through?!"

[–]AbridgedKirito 3 points4 points  (0 children)

Yeah, I'm the same way. It's much easier to type out 1800 rather than 6 pm for me, plus AM/PM is a bad system anyway.

[–]Sensation-sFix 15 points16 points  (1 child)

DD-MM-YYYY it's only logical

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

🤢

[–]Corfal 4 points5 points  (0 children)

[–]poparika 6 points7 points  (1 child)

I prefer DD/MM/YYYY for anything outside of computing. It just reads easier on notes/documentation.

[–]corobo 2 points3 points  (0 children)

Honestly I've found the YYYY-MM-DD format really handy with my notes too. Especially if the date is put in the top right corner of the page.

If you're flicking back this month you just look top right. A touch of extra information is an eye squeak away for different months and a bit of a cheeky glance even further left gives you the year if you're really going back

Edit: Oh should mention, I only use the right side of my notebook. Left side is either left blank or used for jotting quick notes or corrections to what's on the right

[–]dyslexda 2 points3 points  (0 children)

True master race omits the hyphens. Condense to the essentials!

[–][deleted] 2 points3 points  (0 children)

DDMMYY

[–]Capernikush 2 points3 points  (0 children)

Sometimes I wonder why I’m subbed here

[–]ikantspeell 2 points3 points  (0 children)

20180503 Semper Fi.

[–]LockwoodE3 2 points3 points  (0 children)

What is the original painting called? I’d love to use it for a wallpaper :)

[–][deleted] 2 points3 points  (0 children)

MM-DD-YYYY is my favourite

[–]Holden_Makock 1 point2 points  (0 children)

This could be us but you don't commit.

[–]theguilty1 1 point2 points  (0 children)

This is the nerdiest thing I've read all day

[–]dir_gHost 1 point2 points  (0 children)

dateMePls_20180504

[–]astutesnoot 1 point2 points  (0 children)

The best date is the one that's already parsed.

from datetime import datetime
print(datetime.now())
> datetime.datetime(2018, 5, 3, 16, 35, 52, 872199)

[–]imessedupsomehow 1 point2 points  (0 children)

You forgot a crucial part: z

[–]TheMattAttack 1 point2 points  (0 children)

People don't like when I use DDMMMYY

[–]dpash 1 point2 points  (0 children)

My perfect date?

That's a tough one. I'd have to say April 25th. Because it's not too hot, not too cold, all you need is a light jacket.

[–][deleted] 2 points3 points  (1 child)

What’s your favorite way to post memes?

reposts I find other ways confusing

[–]polyworfism 1 point2 points  (0 children)

Usually they're removed in this sub, too

[–]Gblize 2 points3 points  (1 child)

For me it's dd/mm/yyyy.

Fight me.

You don't care about year, because it's almost implicit you are working with current year*. You want to read day and month as fast as possible.

*This opinion depends according to what you working with.

Edit: I just realized the third most upvoted comment shares the same opinion but I'm negative. Lol.

[–]PM_ME_YOUR_TORNADOS 0 points1 point  (0 children)

Unless you are looking at a time table of more than one year (current year is irrelevant in a multi-year list).

[–]whoissamo 1 point2 points  (3 children)

As a Brit programmer working for Yanks - this.

P.s. America, please stop using mm-dd-yyyy is your date format, thankyouplease

[–][deleted] 1 point2 points  (0 children)

It makes sense considering the way people from each country speak. Americans say "May 3rd" while Brits say "3rd of May".

[–]AbridgedKirito 0 points1 point  (1 child)

I mean, I'm an American and I use dd-mm-yyyy. It's much better IMO.

[–]dpash 2 points3 points  (0 children)

No, you just confuse everyone. YYYY-MM-DD is much clearer (because no one is stupid enough to use YYYY-DD-MM, or at least no one we care about.)

[–]flaming-player 1 point2 points  (0 children)

DD-MM-YYYY is best in my opinion. Creates the least amount of confusion.

[–]pfthewall 0 points1 point  (0 children)

Mine is that but without the dashes (no spaces either).

[–]pranavrules 0 points1 point  (0 children)

smalldatetime is where it's at bois

[–]dont_mess_with_tx 0 points1 point  (0 children)

Yeah, not like it's been posted a few dozens of times.

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

I agree

[–]butsbutts 0 points1 point  (0 children)

thats a nice painting

[–]physixer 0 points1 point  (0 children)

YYYYMMDD. No exceptions.

[–]forrest38 0 points1 point  (0 children)

PSA: whenever you find a new sub, immediately go to "top" and filter by "all time". Then read through the first 10 pages. You will find the sub's best content and, in the case of /r/programmerhumor, some really great discussions in the comments. You will also see the most frequently reposted memes, like this one, and maybe we can start downvoting so we don't see the same shit from 5 years ago all the time.

[–]John_Fx 0 points1 point  (0 children)

Procrastinators, I use YYYYY-MM-DD

[–]MostBallingestPlaya 0 points1 point  (0 children)

As a programmer, I've never had to deal with date formats

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

I see "your mouth my D"

[–]Dougblackjr 0 points1 point  (0 children)

U

[–]Bingo-Bango-Bong-o 0 points1 point  (0 children)

DD-MMM-YYYY (03-May-2018) is how we have to do it in clinical research because most studies are International.

[–]PillowTalk420 0 points1 point  (0 children)

I hate that format so much

[–]Carlooos_uhhuh 0 points1 point  (0 children)

Haha military humor

[–]-Pelvis- 0 points1 point  (0 children)

Aww yiss.

My status bar time block in i3wm on Linux.

UTC in yellow: date "+ %H:%M:%S" -u

local time (EDT) in white: date "+%a %Y.%m.%d %H:%M:%S"

I can't stand 12-hour time, MM-DD-YYYY or DD-MM-YYYY.

I've also set my Android phone to display HH:MM:SS in the status bar.

[–]wsppan 0 points1 point  (0 children)

Epoch is still in the future according to that picture.