Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Labels (1)
2 Replies
Anonymous
Not applicable
Author

Hello,

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

Best regards

Sabrina

Anonymous
Not applicable
Author

Hello, 

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

Thnks

Badr