Guru: Date Format Confusion
May 10, 2021 Ted Holt
I use the Copy to Import File (CPYTOIMPF) command to build a CSV file to be sent to a MySQL system. My colleagues are unable to import the file because of the format of a timestamp field. CPYTOIMPF puts a hyphen between the date and time (e.g. 2021-05-10-04.36.24.849555), but the other system wants a space between them. Other than writing a custom program do you know of another way to change the format of the timestamp output?
You won’t need a custom program, Richard. There’s another way to handle this requirement.
IBM has already very thoughtfully …Read more