[resolved] Unparseable Date???

One Star

[resolved] Unparseable Date???

Hi, I would like to fill my database with a TimeStamp, but i get the error "Unparseable Date"???
Look at the Snapshots. In the XML-data, you will see the TimeStamp. The database must get this TimeStamp. How could i do this?
Thanks,
Best regards.

Accepted Solutions
Community Manager

Re: [resolved] Unparseable Date???

Hi
Sorry, the date pattern on the schema should be "MM.dd.yyyy HH:mm:ss" or "dd.MM.yyyy HH:mm:ss".
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] Unparseable Date???

Hi
The date patter on the schema do not match the date, in your case, it might be "MM-dd-yyyy HH:mm:ss" or "dd-MM-yyyy HH:mm:ss".
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Unparseable Date???

Hi shong, thanks for your reply, but your example does not work! I got the same error.
Community Manager

Re: [resolved] Unparseable Date???

Hi
Which components are you using? Can you show us the error message printed on the console?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Unparseable Date???

Look at the snapshots!
Community Manager

Re: [resolved] Unparseable Date???

Hi
Sorry, the date pattern on the schema should be "MM.dd.yyyy HH:mm:ss" or "dd.MM.yyyy HH:mm:ss".
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Unparseable Date???

Thank you very much shong!!!

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch