371
May 16th
(media.piefed.world)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 01 Sep 2025
371 points (100.0% liked)
Facepalm
3383 readers
208 users here now
founded 2 years ago
MODERATORS
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.
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.
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.
Here's atip that might help: Add 19,000,000 to any CYYMMDD date to convert it into YYYYMMDD
I will flex this knowledge at work. Thanks.