For file versioning, this is the way. So when you sort your files by name, your files sort chronologically.
It's also the most relevant information first. I don't care about what day it is if I don't know what month it's in. If it's an unambiguous context they can just be omitted.
Not only that. Processing logs with DD/MM/YYYY in many systems will result in octal base error because of the leading 0 in dates such as 07 08 09, and don't let me talk about how some languages read the back slash / ... pukes in shell
Easily proved to be the best: in every time travel story, the time traveler asks for the date. The unsuspecting drone always responds with DD or MM-DD, and the protagonist has to shout at them “NO! WHAT YEAR IS IT?”
Always start with YYYY.
I rest my case.
DD is day in year, I think dd is what you mean. Also, YYYY is week year, so better to use yyyy.
yyyy-MM-dd
YMD is primarily used in:
China, Japan, South Korea, North Korea, Taiwan, Hungary, Mongolia, Lithuania, Bhutan, Sweden
That is one weird country group.
China and Japan switched from their old calendar system, which was using the start of their current emperor inauguration as the first year, reset with each new emperor.
So I guess it was easier to choose the only correct date format.
That just dictates what number the year starts at, not the order of writing down a date. They do traditionally go from general to specific though. When writing an address in China, you go Country - State - City - Street - Person (I forget where the postal code goes).
I prefer RFC 3339. It allows you to omit the "T" for example. Like this: 1985-04-12 23:20:50Z
Today is 2024, January 24.
It looks perfect. Although my only concern is if we should use the preposition "in" (since the year comes first: "in 2024") or "on" (because we say "on January 24").
It's great when organizing something in a database. You can just do A to Z ordering and it works just fine.
However visually it's not very good because it puts the least important piece of information first and the most important piece of information last. I probably know the current year so it doesn't need to be that prominent, and I'm fairly certain that it's going to be sometime this millennium, so I don't need the date to four digits.
It's entirely depend on the time frame range of your data. If it's wide it rapidly becomes useful to see the year first. In general I like to put 'larger' group variables in tables from left to right, helps in a similar way.
Always write largest to smallest. That way it can be sorted easily starting with the year, then month, then day.
Largest to smallest? So should I write December 02, 2024 as 2024/12/02? And then February 12, 2024 as 2024/12/02?
/s
Unironically yes, because it makes it easy to sort by date.
When you sort by name, the year will get sorted first, then the month, then the day. So it’ll sort like this:
2021-05-19
2021-07-23
2023–06-20
Notice that everything is sorted chronologically. But if you do MM-DD-YYYY then you get this instead:
05-19-2021
06-20-2023
07-23-2021
Notice that the 2023 date is between the two 2021 dates. This is even worse if you do DD-MM-YYYY, because now the first number is changing constantly. It may not be a problem with only three dates, but imagine a spreadsheet with 2000+ entries, or a folder with dozens of files archived by date, to allow for potential rollbacks, versioning, etc…
There’s a reason ISO standards for timestamps list things big to small: YYYY-MM-DD hh:mm:ss in that specific order every time.
You misread. The second part sorts 12 before Feb because 12 > 02, making both dates identical.
I bet you write your time as ss:mm:hh you silly little guy, you small to large clown you. Break up with him babe, you can do better
The 32-bit computers will have no idea what to do once they reach 19 January 2038. They'll have reached their integer limit by that point.
Back in the 2000's it was way more confusing. The appointment is on 10/09/11, when the hell is that?
The "past" is a physical direction, so it should use arrows 8 --> 30.
In the UK it'd be ½ 8, or just 4