AnsweredAssumed Answered

How to insert a specific date string from csv file to Oracle table

Question asked by Xiaoao Wanghu on Oct 15, 2018
Latest reply on Oct 16, 2018 by Ana Gonzalez

I'm using Kettle to import data from csv file to Oracle table. But now I face a date string which is like below:

18-SEP-17 11.47.18.032000 AM ASIA/SHANGHAI

And the corresponding field type in Oracle is Date or TimeStamp.

How could I handle this?

Outcomes