Forum Discussion

Sanssnap's avatar
Sanssnap
New Contributor II
4 years ago

org.joda.time.LocalDateTime error for DB2 Insert

Hi, I had an issue with DateTime conversion issues Insert records when migrating data from MySQL to DB2. MYSQL dateformat : 2022-03-17 05:10:10 DB2 timeformat 2022/03/17 05:10:10 I am getting ...
transform
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago
Copy LinkReport

Try parsing the date into the specific format:

Date.parse('2022-03-17 05:10:10','yyyy-MM-dd HH:mm:ss').toLocaleDateTimeString({'format':'yyyy/MM/dd HH:mm:ss'})