Could not parse column as timestamp

Four Stars

Could not parse column as timestamp

Hello,

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

Moderator

Re: Could not parse column as timestamp

Hello,

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

Best regards

Sabrina

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

Hello, 

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

Thnks

Badr

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.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads