Four Stars

Could not parse column as timestamp


I need your help in this issue

I have a talend job which load data from a table to another with a simple tmap.

I called it a mysterious error because it happended just for a specific datetimes


java.sql.SQLException: Could not parse column as timestamp, was: "2009-06-01 00:00:00"

Thousands of rows before the row containing this line doesn't generate the error

When I modify this date 2009-06-01 00:00:00 to another or just changing the day part or the month or even the hour, It goes without error.

the datasource is a mariadb and the destination is a Mysql database

the field is a datetime in the source database and the destination too.

thnks for your help


Re: Could not parse column as timestamp


Could you please also indicate on which talend build version you got this issue?

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Could not parse column as timestamp


I had the same error in 6.3 and 6.4 (TOS DI)