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

Seven Stars

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

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


Accepted Solutions
Employee

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

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 :-)


All Replies
Employee

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

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 :-)

Employee

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

@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 :-)

Five Stars

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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog