The Picard Maneuver@piefed.world to Facepalm@lemmy.worldEnglish · 7 days agoMay 16thmedia.piefed.worldimagemessage-square90fedilinkarrow-up1383arrow-down121
arrow-up1362arrow-down1imageMay 16thmedia.piefed.worldThe Picard Maneuver@piefed.world to Facepalm@lemmy.worldEnglish · 7 days agomessage-square90fedilink
minus-squareitisileclerk@lemmy.worldlinkfedilinkarrow-up1·6 days agoActually, 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).
minus-squareano_ba_to@sopuli.xyzlinkfedilinkarrow-up3·6 days agoAs 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.
minus-squarepfwood178@sh.itjust.workslinkfedilinkarrow-up1·6 days agoOr 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.
minus-squareano_ba_to@sopuli.xyzlinkfedilinkarrow-up2·6 days agoYeah, 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.
minus-squarepfwood178@sh.itjust.workslinkfedilinkarrow-up2·6 days agoHere’s atip that might help: Add 19,000,000 to any CYYMMDD date to convert it into YYYYMMDD
minus-squareano_ba_to@sopuli.xyzlinkfedilinkarrow-up2·5 days agoI will flex this knowledge at work. Thanks.
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).
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.