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 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.