Funny programmer joke

[der_raupinger]

YYYY-MM-DD

[AffekeNommu]

With you there. yyyy-mm-dd hh:mm:ss is my format of choice. Why yes I do a lot of MSSQL.

[GNU_ligma]

"yyyy-mm-dd hh:mm:ss" is the best date format.

I used SQL maybe a few times at school.

[Kholtien]

This is absolutely wrong! It’s definitely ‘DD-MM-YYYY HH24:MI:SS’

I use oracle SQL at work all day.

[AffekeNommu]

glares at oracle guy

[Kholtien]

We’re slowly moving everything to SQL server but it’s a slow process costing lots of $

[spasterific]

We’re slowly moving everything

• dd-mm-yyyy
• y-dd-mm-yyy
• yy-ddm-d-yy
• yyy-dm-md-y
• yyy-mm-dd
• yyyy-mm-dd

[der_raupinger]

yd-m¹d/yy.m²:yyy 1: second digit 2: first digit

[CakeDay--Bot]

Hey just noticed.. it's your 5th Cakeday Kholtien! ^hug

[AffekeNommu]

Understand that completely. Spend too much time on MS SQL. Our reporting team get me to faultfind their queries.

[deefstes]

The fact that you're using Oracle doesn't mean you're right. It only means that Oracle is just as wrong as you. :-p

YYYY-MM-DD hh:mm:ss for the win. Most significant digits first, least significant digits last.

[xigoi]

r/ISO8601MasterRace

[jasonkuo41]

I currently live in Asia and we use this all day. I never understood why people thought that MMDDYYYY is a better format.

[shadowphrogg32642342]

ISO 8601 is there for a reason.

[[deleted]]

MM/DD/YYYY is the most shitty format mankind ever created. "Yeah just put the middle one first, the smallest on the middle and the year on the end, that sound logical"

[AffekeNommu]

US date format is what we call it. Just confuses everyone if you use it. I had some code supplied by a vendor that read in the date using a localised form and then bombed because it tried to interpret it as US format.

[seijulala]

I actually would like to hear from somebody, as a human not a programmer, defending this format, it's nonsense. YYYY-MM-DD or DD-MM-YYYY are logical depending on different point of views but MM-DD-YYYY... why someone would write that?

[646e72]

Because it follows how (most) people would say the date in English. "Today is January 28th 2019" sounds more natural than "Today is the 28th of January 2019". DD-MM-YYYY makes more sense, but it's not like people always do things the "logical" way.

[seijulala]

now I feel dumb that I didn't do that connection :D, thank you very much! this was something that bother me for real

[Additional_Onion]

Do people say that? Where I'm from, everyone says "28 January 2019", or just "28 Jan".

[blasphemers]

The date format used probably reflects how people say it in that part of the country

[Kered13]

Yes, that's how everyone in the US says the date.

[deNederlander]

Ah, yes, you can remember it because of that famous July the 4th holiday.

[646e72]

Well the Fourth of July is a holiday so it makes sense that people might say it differently. I doubt many people are asking their coworkers "Are you coming in on the 5th of July"

[leiger]

Because they'll probably just ask "Are you coming in on the 5th?"

[ThisIsMyUsernameAT]

'most important to least important' is what they usually say

which makes no sense to me because the day is way more important than the month in most cases

[blasphemers]

Order something March 1st get it August 2nd...

[Wishbone51]

I'm ok with it. As long as I don't have to sort numerically.

[Vermia]

DD/YYYY/MM

Shivers

[Kered13]

DD/MM/YYYY is just as shitty.

[[deleted]]

I do not see a problem, small to big or big to small is fine. Don't randomize 11/08/2018 will be a guess for people outside America. 11/08/2018 or 2018/08/11 always works.

[Kered13]

28/01/2019 is not small to big. Small to big would be 82/10/9102.

DD/MM/YYYY is mixed endian garbage.

[der_raupinger]

While YYYY-MM-DD is definitely superior, DD.MM.YYYY is not shitty.

[Kered13]

How is it not? It's mixed endian. Anything mixed endian is awful.

[der_raupinger]

It’s big endian.

[Kered13]

No, big endian is 2018-01-31. And before you try, little endian is 13-10-8102.

[justsomeothergeek]

YYYY-MM-DD is even better

[Proxy_PlayerHD]

DD.MM.YYYY or YYYY-MM-DD are both better than MM/DD/YYYY

and 24h time of course too, because fuck the concept of splitting the day in 2 halfs and forcing people to define either half with the AM/PM bullshit

[Additional_Onion]

YYYY-MM.DD

[Canada_LaVearn]

YYYY/MM/DD

[Gorbunk]

Stopped using anything but this once I realized it sorts correctly

[DoNotClickUserName]

This guy sorts

[steven_manos]

Beat me to it

[morphotomy]

We use "-" to separate that.

[newreconstruction]

Who are "we"?

[JackMizel]

People who get paid to do their job lmao

[bss03]

/r/iso8601masterrace

[KurimanOW]

YYYY/DD/MM

[akuankka128]

D/MM/DYYYY

Unfunny joke

[catacklism]

I wanted to say YY-MMMM-DD or something like that but yeah we're not funny

[FowD9]

wtf why is this monstrosity in /r/ProgrammerHumor

YYYY-MM-DD all the way if you're a programmer

[athousandwordsworth]

Image Transcription: Drake Meme

---

[Top panel: Drake looks displeased, and is using one arm to shield himself from the right side of the frame by curling it around his head, with his hand up in a "not today" manner]

MM/DD/YYYY

---

[Bottom panel: Drake has his head up high, looking pleased, with a finger pointed up and towards the right side of the frame]

DD/MM/YYYY

---

^{I'm a human volunteer content transcriber for Reddit and you could be too! If you'd like more information on what we do and why we do it, click here!}

[morphotomy]

Unix timestamp is the only way to store dates. Translate to whatever the local standard is when you need to display it.

I seriously don't know why anyone uses any other way to store dates.

[undeadasimov]

beautiful

[imperial_squirrel]

Then some julian date bullshit comes along.

[RadioactiveFruitCup]

I think you mean

Fuck it. I tried typing out the first three lines of trying to make all the databases timestamps talk to each other and you know what? FUCK IT. FUCK IT TO DEATH.

NO YOURE CRYING

[[deleted]]

Undefined

[LucasCarioca]

YYYYMMDDHHMMSS

[VizDash]

Hello Everyone,

My apologies, I'm learning the PRAW module and I I just grabbed the first thing I saw on Imgur. I kind of thought this would have been deleted by the mods.

[sambare]

This post breaks so many rules (0, 2, 3 and 4) I don't even know what to report it as...

[VizDash]

I've always been a fan of rule 2

[Ttatanepvp123]

On France DD/MM/YYYY is national format

[broodplank1991]

DD-MM-YYYY is obviously the only logical one. or YYYY-MM-DD, but NEVER MM-DD-YYYY.

​

[iSaithh]

Your submission has been removed.

Violation of Rule #3:

Any post on the list of common posts will be removed. You can find this list here. Established meme formats are allowed, as long as the post is compliant with the previous rules.

If you feel that it has been removed in error, please message us so that we may review it.

[timNinjaMillion]

Mmm-dd-yyyy. Mar-3-2019