java.lang.RuntimeException: Unparseable date: "2014-05-12 16:07:10.691"

[sbxr]

Hi 

my data is in csv having one field as date format mm/dd/yyyy HH:mm:ss

when I am running job throwing error : 

Couldn't parse value for column 'last_modified' in 'row1', value is '2014-05-12 00:36:57.996'. Details: java.lang.RuntimeException: Unparseable date: "2014-05-12 00:36:57.996"

In my data the field is in mm/dd/yyyy hh:mm:ss format

how can resolve this issue

[Anonymous · Accepted solution]

Hi,

   First thing you need to do is to open the file in a normal text editor like notepad, notepad++ etc. to verify the actual date format.

   If you are opening in Excel, it will auto format the data before displaying. Once the actual data format is identified, you can add the date in corresponding format.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

@sbxr 

  Did it resolve your issue?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[vikramk]

you can't open the excel file in notepad++ if you still try to open you can't even try view the data I do have the same issue and the date format is in this format - 8/31/2018 8:33:41 PM
So I tried to gave format as "MM-dd-yyyy HH:mm:ss" it throws same error as mentioned in the post