Facepalm

3383 readers

300 users here now

founded 2 years ago

MODERATORS

irelephant@lemmy.world

The_Picard_Maneuver@lemmy.world

irelephant@lemmy.dbzer0.com

360

May 16th (media.piefed.world)

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

90 comments fedilink hide all child comments

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

[–] ano_ba_to@sopuli.xyz 20 points 6 days 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 6 days 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 6 days 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 6 days 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 6 days 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 6 days 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 6 days ago

I will flex this knowledge at work. Thanks.