Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Could you please also indicate on which talend build version you got this issue?
Best regards
Sabrina
Hello,
I had the same error in 6.3 and 6.4 (TOS DI)
Thnks
Badr