we are currently having an issue regarding uploading timestamps to an Oracle database. The column type in the database is TIMESTAMP, and we would like to upload it as a string.
No problems so far, we have synced the receiving and uploading types as strings, and we use the getCurrentDateString service, with “yyyy-MM-dd-HH.mm.ss.SSS” pattern.
The upload proceeds and works without errors, however, when we check the database, we notice, that the dates are not accurate at all.
The time and day seem to be working, but the month and year parameters display extremely wrong values at certain times, in a random manner.
Any help and ideas are greatly appreciated.