363
submitted 9 months ago by Stamets@lemmy.world to c/funny@lemmy.world
you are viewing a single comment's thread
view the rest of the comments
[-] mathematicalMagpie@lemm.ee 44 points 9 months ago

Always write largest to smallest. That way it can be sorted easily starting with the year, then month, then day.

[-] deegeese@sopuli.xyz 16 points 9 months ago

Or as computer people say, big-endian.

[-] uis@lemmy.world 1 points 9 months ago

Computer ponies say it too

[-] douglasg14b@lemmy.world 7 points 9 months ago

We should all just write it in ISO 8601

[-] PR3CiSiON@lemmy.world 5 points 9 months ago

Largest to smallest? So should I write December 02, 2024 as 2024/12/02? And then February 12, 2024 as 2024/12/02?

/s

[-] PM_Your_Nudes_Please@lemmy.world 2 points 9 months ago

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.

[-] Randelung@lemmy.world 14 points 9 months ago

You misread. The second part sorts 12 before Feb because 12 > 02, making both dates identical.

[-] SuckMyWang@lemmy.world 2 points 9 months ago

What if I want to easily sort the day or month?

this post was submitted on 23 Jan 2024
363 points (84.1% liked)

Funny: Home of the Haha

5640 readers
599 users here now

Welcome to /c/funny, a place for all your humorous and amusing content.

Looking for mods! Send an application to Stamets!

Our Rules:

  1. Keep it civil. We're all people here. Be respectful to one another.

  2. No sexism, racism, homophobia, transphobia or any other flavor of bigotry. I should not need to explain this one.

  3. Try not to repost anything posted within the past month. Beyond that, go for it. Not everyone is on every site all the time.


Other Communities:

founded 1 year ago
MODERATORS