Could not parse column as timestamp

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)



What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.


Downloads and Trials

Test drive Talend's enterprise products.