Facepalm

3415 readers

21 users here now

founded 2 years ago

MODERATORS

irelephant@lemmy.world

The_Picard_Maneuver@lemmy.world

irelephant@lemmy.dbzer0.com

350

May 16th (infosec.pub)

submitted 1 month ago by The_Picard_Maneuver@piefed.world to c/facepalm@lemmy.world

80 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] PyroNeurosis@lemmy.blahaj.zone -2 points 1 month ago* (last edited 1 month ago) (5 children)

I hold unequivocally that 2SEPT2025 is the best dating format: the units are in order from small to big, and the use of letters for month both break up the reading for a more concrete understanding and also make it unambiguous.

Edit: folks big on computerizing this shit. My bad. I find this to be optimal for human use.

[–] ano_ba_to@sopuli.xyz 20 points 1 month ago (1 children)

Natural numbers work backwards, units are in order from big to small. That also does not store well on databases or Excel. You can't sort it as text. YYYY-MM-DD-hh-mm

[–] itisileclerk@lemmy.world 1 points 1 month ago (1 children)

Actually, the date and time format is: yyyy-MM-dd-HH-mm. Always 12 characters, can be sorted as text or long (if the - is removed).

[–] ano_ba_to@sopuli.xyz 3 points 1 month ago (1 children)

As long as it's easy to manipulate at the back end. IBM DB2 date/time format uses 25 characters, and includes 6 decimal places for the seconds.

[–] pfwood178@sh.itjust.works 1 points 1 month ago (1 children)

Or the DB2 date (only) format which is 7 characters: CYYMMDD
C = 1 if year is greater than 1999 as a "fix" for Y2K problems. 1250902 is today's date. 250902 was exactly 100 years ago.

[–] ano_ba_to@sopuli.xyz 2 points 1 month ago (1 children)

Yeah, that's what I'm dealing with these days...sigh. It won't be a problem for a while. Hopefully the AI of the future is trained for the edge case.

[–] pfwood178@sh.itjust.works 2 points 1 month ago (1 children)

Here's atip that might help: Add 19,000,000 to any CYYMMDD date to convert it into YYYYMMDD

[–] ano_ba_to@sopuli.xyz 2 points 1 month ago

I will flex this knowledge at work. Thanks.

[–] Routhinator@startrek.website 5 points 1 month ago

Cool. Now have it sort by date in a column with simple alphanumeric ordering.

[–] Obi@sopuli.xyz 4 points 1 month ago

Except for all the languages that might have a different spelling for the months..

[–] tomenzgg@midwest.social 3 points 1 month ago

Even in human use, – in nearly any given scenario – I care about the month far beyond and above before I ever care about the day; just knowing the day, without knowing the month, is useless to me while I may want to know about the month regardless the day.

[–] prole@lemmy.blahaj.zone 3 points 1 month ago* (last edited 1 month ago) (1 children)

Why is it important that they're listed small to big? How does that help?

[–] Madrigal@lemmy.world 1 points 1 month ago (1 children)

For the same reason it matters that we’ve agreed on a particular order to the alphabet.

[–] prole@lemmy.blahaj.zone 1 points 1 month ago

Ok, but if you use YYYY-MM-DD, you can sort alphabetically, and it will also sort chronologically.