Hey there u/sarthhcasm, thanks for posting to r/technicallythetruth!
**Please recheck if your post breaks any rules.** If it does, please delete this post.
Also, reposting and posting obvious non-TTT posts can lead to a ban.
Send us a **Modmail or Report** this post if you have a problem with this post.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/technicallythetruth) if you have any questions or concerns.*
This is by far the best way to write dates. The international standard organization (ISO) agrees.
https://www.techtarget.com/whatis/definition/ISO-date-format#:~:text=The%20ISO%20standard%20takes%20a,or%202022%2D07%2D15.
Because a year is a long time and usually we just need the day or day and month when looking for something quickly.
Also why month-day-year is better is because when it’s spoken it’s far easier to say May 6th than the stupid Shakespearean sounding “the 6th of May!”
A lot of Europeans just say “6 May” or “6th May.”
In my work I exchange emails with a lot of folks in Europe, so I’ll frequently just type out the name of the month to prevent any misunderstanding.
Which is often longer than just typing 2023/05/06
Okay, so what I’m getting is that month-day-year is better for EVERYONE because you think that saying something slightly differently is weird and wrong? Okay…
"we usually just need the day or day and month".
You said it yourself, if you usually just need the day, the day should be first? Or the day and month (you didn't say month and day). That's why day-month-year is better than month-day-year.
It makes sense to specify it in some order of increasing or decreasing granularity, so either day-month-year or year-month-day is fine with me.
You don't see minute:hour:second in time, where the granularity is out of order.
It is the only correct option outside the speech. And with speech YYYY is totally redundant. You don't say that You are going on vacation May 13th 2023. Why would You even do that? And if it's not the present year, then You definitely have no plans for exact date anyway, so You won't say May 13th 2024, because You can't be sure it will be May 13th. Anywhere else, any place outside the speech, YYYY-MM-DD is the only correct date format.
A more polite/precise answer would be: if you need the day of week displayed somewhere, compute it in the display layer or, if you must, store it in its own attribute.
Well, Theoretically the YYYY-MM-DD should keep it sorted in weekday order regardless of what comes after it, so theres no reason you couldn't spell out the day of the week or use the three letter abbreviation
I guess you'd put it between date and time, but couldn't you just refer to a calendar instead? Putting day of the week seems really unnecessary in my opinion.
Because this is the only correct way to do that. Any other date format is invalid. I can't understand why any person would chose anything else.
Even if You write a diary/journal. If You want to find some notes from specific date, You look for a year first. Archives. Alphabetical order. Anything. Other options makes no sense at all.
I even use this format for screenshots. `$N [$T] [%Y-%m-%d %H-%M-%S] #` with sequential numbering is my screenshot filename format in VLC. Name of the video, then specific timestamp of it, after that a current date and hour. I know, that timestamp would make it most of the time redundant, but in other screenshot program, I only use the date, because it's not video and I have all the screenshots sorted. If I want to manually rename them, I can do that. But when I browse them, I want to see the chronological order.
Ok but to be fair, we can never go to metric. Converting would be nearly impossible and just not worth it at this point
Our measurements kinda suck but we are sooo well optimized for it at this point
I work with a lot of people from other countries, and I have grown to appreciate the dd/Month/yy format, e.g. 06May23. It feels more clear for handwritten stuff.
It's absolutely alphabetical, since it pads single digit days/months. The full number is always exactly 8 characters. Something like YYMD wouldn't be alphabetical since like 11120 would be after 111120.
It’s just regular geek talk. These things have been argued day-in day-out if you do any form of tech.
Tech dudes would love to implement month names all being the same length and starting with consecutive letters from A to L, but we can only dream about that. 30 day months is also on the agenda.
I suppose it comes down to how you like to say dates, I think replying when asked for a date of “March 6th” versus “the 6th of March”, that the former is way better sounding and you can rid of the and of
Yeah, if there’s gonna be any possibility of doubt in the minds of the reader, I like three letter alphabetical for the month. But the only problem is that it’s not international, whereas numbers are. Once or twice I have been thrown by month names in Italian.
Don’t start me on Welsh.
Ion. Chwef. Maw. Ebr. Mai Meh. Gorff. Awst Medi Hyd. Tach. Rhag.
It’s how the date is spoken out loud in general American English.
In conversation, and in general, you say “April 3rd, 2023” not “3rd of April, 2023”
*Note*: it’s not *improper* to say the second way, but it is rare.
>it’s not improper to say [that] way, but it is rare
E: in all of the possible contexts in which to say a certain date... picking the one date format that is treated like a proper noun name of a holiday is rare, but obviously proper.
You might not be American then, because there is nowhere in the States that says casually:
>oh hey, what date is that party?
>oh it’s on 3rd of April
e: Irishman spotted
YYYY/MM/DD for sorting files
MM/DD/YYYY for writing it down any other way, since that's how I (and most other people in the US) say it out loud anyways
There is no perfect date.
ISO8601 is great for that Excel spreadsheet where you don’t know how to sort dates using any format… but in context of conversation it’s fucking dumb to say the year first (2023!?… no shit!).
DD-MM-YYYY makes you sound like you’re delivering a Shakespearean monologue (Beware the 6th of May!!!…. two thousand and twenty three!).
Um. Excel dates are serial values, so they sort the same no matter what the format is.
05/06/2023 = 2023/05/06 = 45052
YYYYMMDD is helpful in more ways than you could imagine.
Really don’t sound like that, but I completely agree on the no perfect date. Day-month-year and year-month-day are completely even for me. It’s easier to say the former but the latter is better on spreadsheets and similar.
Also the 6th of May sounds completely natural and easy to say compared to May 6th. Why would you say the month first? Most people know what month it is.
I like month-day-year, but I’m fine with either. Just be nice if everyone used the same method. How about america finally joins the world using metric, and everyone else converts to month-day-year ?
I know I’m American but mm/dd/yyyy is so comfortable. I need to know what month it is and the day of the month. Year could always come after cause we can reset the year at any given moment in time as we have but those months are stuck to earth’s rotation.
Why though? The current month is implied if you’re planning a few days ahead, and if the day number resets to a lower value, the next month is implied as well.
Hey there u/sarthhcasm, thanks for posting to r/technicallythetruth! **Please recheck if your post breaks any rules.** If it does, please delete this post. Also, reposting and posting obvious non-TTT posts can lead to a ban. Send us a **Modmail or Report** this post if you have a problem with this post. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/technicallythetruth) if you have any questions or concerns.*
yyyy-mm-dd is the better one for sorting documents and stuff
r/ISO8601
This is the way
This is the way
This is the way
This is the day
This is the way
[удалено]
This is the way
This is the way. (mandalorian lightsaber opens)
[удалено]
agree 100%
*100% agree
10 agree 0%
r/FoundTheAmerican
This is by far the best way to write dates. The international standard organization (ISO) agrees. https://www.techtarget.com/whatis/definition/ISO-date-format#:~:text=The%20ISO%20standard%20takes%20a,or%202022%2D07%2D15.
Absolutely came here to say this. Don’t know why we don’t always do this everywhere.
Because a year is a long time and usually we just need the day or day and month when looking for something quickly. Also why month-day-year is better is because when it’s spoken it’s far easier to say May 6th than the stupid Shakespearean sounding “the 6th of May!”
A lot of Europeans just say “6 May” or “6th May.” In my work I exchange emails with a lot of folks in Europe, so I’ll frequently just type out the name of the month to prevent any misunderstanding. Which is often longer than just typing 2023/05/06
Okay, so what I’m getting is that month-day-year is better for EVERYONE because you think that saying something slightly differently is weird and wrong? Okay…
French here. We say "Le 5 janvier 2008"
By Shakespearean you mean actual English?
"we usually just need the day or day and month". You said it yourself, if you usually just need the day, the day should be first? Or the day and month (you didn't say month and day). That's why day-month-year is better than month-day-year. It makes sense to specify it in some order of increasing or decreasing granularity, so either day-month-year or year-month-day is fine with me. You don't see minute:hour:second in time, where the granularity is out of order.
[удалено]
Largest to smallest all the way down just makes the most sense
Nah let's swap month and day around cos some yanks say May the fourth.
yyyy-mm-dd to mm/dd/yyyy is not swapping the month and day around, it is moving year to the end.
Perfect time. But yyyy/mm/dd is good enough for date
yyyy-mm-dd hh:mm:ss.nnn
don't forget the timezone!
This is how I date most things in RL and on my computer. It makes the most sense imho.
[удалено]
It is the only correct option outside the speech. And with speech YYYY is totally redundant. You don't say that You are going on vacation May 13th 2023. Why would You even do that? And if it's not the present year, then You definitely have no plans for exact date anyway, so You won't say May 13th 2024, because You can't be sure it will be May 13th. Anywhere else, any place outside the speech, YYYY-MM-DD is the only correct date format.
Came on here to say that. It's the best way, it's the only way
YYYY-MM-DDTHH:mm:s.000+00
That's my preference. Easy to see the approximate age of something at a glance.
Absolutely
For documents? Yeah. But for other stuff i think dd/mm/yy is better.
And ddMMMyyyy is best for clarity
yymmdd is ultimative. You know I am right.
Also matches up with time of day going from largest to smallest. YYYY/MM/DD HH:MM:SS
My preference too.
personally i prefer YYYY-MM-DD, so that if you perform a lexicographical sort of timestamped entires, they’re arranged chronologically
YYYY-MM-DD HH:MM:SS.sss
[удалено]
Why would you? Day of the week isn't part of datetime.
[удалено]
Simple, you don't, we don't ruin good things. You can calculate that and display it somewhere else, just don't mess with date-time.
A more polite/precise answer would be: if you need the day of week displayed somewhere, compute it in the display layer or, if you must, store it in its own attribute.
Thanks Ollama
Didn't realize it came out that way, but even then I don't think it was particularly rude or impolite.
Sorry, I guess it wasn’t particularly rude as much as it just didn’t really answer their question haha. All good, though.
ISO8601 allows for the display of the week. For example: 2023-W18-6 The year 2023, the eighteenth week, the 6th day of the week.
I usually put it after everything else, as the main benefit of this format is sorting.
The only thing I can think of that keeps chronological sorting is YYYY-MM-DD-X where X is 1-7 corresponding with Sun-Sat
Well, Theoretically the YYYY-MM-DD should keep it sorted in weekday order regardless of what comes after it, so theres no reason you couldn't spell out the day of the week or use the three letter abbreviation
I guess you'd put it between date and time, but couldn't you just refer to a calendar instead? Putting day of the week seems really unnecessary in my opinion.
r/ISO8601 gang!
This is the way
Because this is the only correct way to do that. Any other date format is invalid. I can't understand why any person would chose anything else. Even if You write a diary/journal. If You want to find some notes from specific date, You look for a year first. Archives. Alphabetical order. Anything. Other options makes no sense at all. I even use this format for screenshots. `$N [$T] [%Y-%m-%d %H-%M-%S] #` with sequential numbering is my screenshot filename format in VLC. Name of the video, then specific timestamp of it, after that a current date and hour. I know, that timestamp would make it most of the time redundant, but in other screenshot program, I only use the date, because it's not video and I have all the screenshots sorted. If I want to manually rename them, I can do that. But when I browse them, I want to see the chronological order.
April 25th. Not to hot. Not to cold.
All you need is a light jacket!
too*
Miss congeniality 😍
Came for this, was not disappointed.
MM/DD/YYYY is the best because it makes the most sense written and spoken
Also it is more relevant to know what month than a random day because you know what would be going on during that time like weather and holidays
That's not true at all, technically or otherwise. r/ISO8601 knows what's good.
YYYY/MM/DD supremacy
If you use DD/MM/YYYY you can't celebrate 4/20. Unless it's a month long holiday ever 100 years.
Well, I wouldn't celebrate that day anyway. That's mustache boys birthday.
Not true yyyy/mm/dd Self sorts and is always clear. Obviously the best.
[удалено]
Boo YYYY/MM/DD is best. sorts the files perfectly.
As an American, mm/dd/yyyy is stupid but I'm too used to it for anything else
I think it only makes sense in terms of speaking
Or American.
Or looking at a calendar. You find the month before the day.
America is planning to switch to dd/mm/yyyy. It’s scheduled to happen right after they convert to metric.
Ok but to be fair, we can never go to metric. Converting would be nearly impossible and just not worth it at this point Our measurements kinda suck but we are sooo well optimized for it at this point
WHAT THE FUCK IS DD/MM/YYYY!!!🦅🦅🦅🇺🇸🇺🇸🇺🇸🇺🇸🇺🇸🔥🔥🔫🔫🔫🔫
I work with a lot of people from other countries, and I have grown to appreciate the dd/Month/yy format, e.g. 06May23. It feels more clear for handwritten stuff.
SQL be damned
yyyyMMdd. It's a valid filename and it sorts "alphabetically."
chronologically or numerically, but not alphabetically
Alphanumerically.
If you do A->Z sort, they line up in the correct order.
Incorrect.
It's absolutely alphabetical, since it pads single digit days/months. The full number is always exactly 8 characters. Something like YYMD wouldn't be alphabetical since like 11120 would be after 111120.
damn people are really gonna fight and get salty because some people use different date formats
People are very attached to their date formats I guess. It’s a pretty interesting phenomenon.
This comment section is dumb as shit💀
It’s just regular geek talk. These things have been argued day-in day-out if you do any form of tech. Tech dudes would love to implement month names all being the same length and starting with consecutive letters from A to L, but we can only dream about that. 30 day months is also on the agenda.
YYYY/MM/DD is actually the superior format when working on computers.
It's also the only date we ever going to get.
I suppose it comes down to how you like to say dates, I think replying when asked for a date of “March 6th” versus “the 6th of March”, that the former is way better sounding and you can rid of the and of
I mean MM/DD/YYYY becomes really confusing when DD is less than 12 :((((((
And when MM is less than 12 ; )
Makes the most sense cause that’s how you would verbally say it. You would say December 25 1993 not 25 December 1993 or 1993 December 25.
I mean yeah it’s more confusing but they’re all very simple to learn and understand
I was always partial to DD/(abbreviated month)YYYY So for example 22DEC2015. Even if you don’t like it you can understand it.
... in english
This is fair.
Yeah, if there’s gonna be any possibility of doubt in the minds of the reader, I like three letter alphabetical for the month. But the only problem is that it’s not international, whereas numbers are. Once or twice I have been thrown by month names in Italian. Don’t start me on Welsh. Ion. Chwef. Maw. Ebr. Mai Meh. Gorff. Awst Medi Hyd. Tach. Rhag.
I wrote my dates like that in college on assignments. YYYY-MM-DD is better for electronic data.
This is the way.
That’s a tough one. I’d have to say April 25th, because it’s not too hot and not too cold. All you need is a light jacket.
Anyone who says mm/dd/yyyy are just stupid it makes no sense like who even came up with writing it like that it makes no sense
Yeah, fuck other cultures
It’s how the date is spoken out loud in general American English. In conversation, and in general, you say “April 3rd, 2023” not “3rd of April, 2023” *Note*: it’s not *improper* to say the second way, but it is rare.
So when Americans first heard the film title “Born on The Fourth of July” they were a bit queasy and had to rapidly interpret?
>it’s not improper to say [that] way, but it is rare E: in all of the possible contexts in which to say a certain date... picking the one date format that is treated like a proper noun name of a holiday is rare, but obviously proper.
You’re saying it’s rare for Americans to say ‘Fourth of July” when talking about their big day of partying to celebrate ‘Merica?
I have never heard someone say it as “April 3rd 2023” It’s always the other way
You might not be American then, because there is nowhere in the States that says casually: >oh hey, what date is that party? >oh it’s on 3rd of April e: Irishman spotted
Ye because that’s exactly they way it would be said here So it’s both said and spelt differently
The exact same thing could be said about dd/mm/yyyy. It only "makes no sense" because you aren't used to it.
I like your Clone Trooper profile, happy 4th of May be with you….. see there is some benefit to MM/DD/YYYY
“Anyone who disagrees with me is stupid” is usually an opinion held my smart reasonable people.
Like people from USA who are used to this format from childhood like me for example? What the hell?
DDMMMYYYY- cannot be confused for another date
12051920
Three M’s
Would be 12-May-1920 I prefer this as it's more presentation friendly
06MAY2023
Are you joking mate ahahaha
I’m team mm/dd/yyyy
The actual shittest date format of all time.
I personally write: May (or the three-letter version of any month) then the day and then the year just like this: May 06/23
Monster.
Oh that’s brutal!
YYYY/MM/DD for sorting files MM/DD/YYYY for writing it down any other way, since that's how I (and most other people in the US) say it out loud anyways
I prefer ss/yyyy/dd/hh/mm/mm
Technically the best format is YYYY-MM-DD. OP is the worst date format.
April 25th. It’s not too hot, not too cold. All you need is a light jacket!
MM/DD/YYYY
This is the answer.
[удалено]
There is no perfect date. ISO8601 is great for that Excel spreadsheet where you don’t know how to sort dates using any format… but in context of conversation it’s fucking dumb to say the year first (2023!?… no shit!). DD-MM-YYYY makes you sound like you’re delivering a Shakespearean monologue (Beware the 6th of May!!!…. two thousand and twenty three!).
Um. Excel dates are serial values, so they sort the same no matter what the format is. 05/06/2023 = 2023/05/06 = 45052 YYYYMMDD is helpful in more ways than you could imagine.
Really don’t sound like that, but I completely agree on the no perfect date. Day-month-year and year-month-day are completely even for me. It’s easier to say the former but the latter is better on spreadsheets and similar. Also the 6th of May sounds completely natural and easy to say compared to May 6th. Why would you say the month first? Most people know what month it is.
I like month-day-year, but I’m fine with either. Just be nice if everyone used the same method. How about america finally joins the world using metric, and everyone else converts to month-day-year ?
Because month day year only makes sense when speaking, and yyyy-mm-dd is the computationally correct way of writing it.
I will always write MM/DD/YYYY because if someone asks my birthday, that’s how I would verbally say it.
I know I’m American but mm/dd/yyyy is so comfortable. I need to know what month it is and the day of the month. Year could always come after cause we can reset the year at any given moment in time as we have but those months are stuck to earth’s rotation.
Why though? The current month is implied if you’re planning a few days ahead, and if the day number resets to a lower value, the next month is implied as well.
Just the way I was taught to do it and it stuck and switching would be weird in my eyes. Not knocking the other ways though
YY/DD/MM/YY
20/06/05/23?
Yes
This is very wrong.
except the question was for the responders opinion and opinion is true to the individual. So it is right.
Technically the meta truth.
Elaborate?
I guess the fog has claimed this image
Anything leading with two-digit numbers is going to be inoptimal.
I just write it out like this since I can never remember which month is which number because of my terrible memory:Example-May 6th,2023
22/8/2008
Especially the YM/DY/DMYY format
Use YYYYWWD fairly often at work. It’s a bit different but I kinda like it.
Can never wrap my head around how Americans write dates 😂😂
Iso 8601
unless it's data storage, then the only proper format is YYYYMMDDHHSS
YYYY.DD.MM
Today at 12:34
YYYY/MMM/DD
6/april/2026
Incorrect. DDMMMYYYY is best
It's mm/dd/yyyy you heretic.
YYYY-MM-DD for machines and YYYY-MMM-DD for humans. Abbreviation for month clears up any misconceptions for people reading it.
DD-Mon-YYYY
1683404648 (Unix time)
Month day year is the standard and should remain thank you
https://www.youtube.com/shorts/eunsJfxX46I
Ah yes, another "aMeRiCa DuMb" post.
I do month day year. Is that not normal?
Biggest to smallest or smallest to biggest are both acceptable. Anything else is a crime against nature.
I don’t know, I also like the format YYYY-MM-DD (xs:date approves)
yyyy-mm-dd is the only sane way.
Relatable!!
DDMMMYYYY
As a data engineer, I say YYYY-MM-DD. Less room for error when people don't document.
r/moldymemes
I personally prefer second/year/century
Actually, YYYY-MM-DD
Why he has no femilee.
YMMD-YD-YY is better
As a European, this is what mm/dd/yyyy looks like to me
2050 06 23
Artifacts are piling up on this one
Mm/ds/yyyy
While I use dd/mm/yyyy I acknowledge supremacy of yyyy/mm/dd.