Search code examples
datetalend

Date format in Talend "2006-05-27 17:00:00.000"

I am facing an issue with Talend dates. I have tried several solutions but still an "unparseable date" error persists.

My date format is of the form : "2006-05-27 17:00:00.000" Can you help me ?

Solution

  • If you don't handle the conversion yourself in a tMap but just want to use a schema, then: In your mapping configuration in the date field, you can add the following string:

    yyyy-MM-dd HH:mm:ss.SSS

    to set the correct format mapping for the date string. Otherwise the answer of garpitmzn is the way to go.