Purpose:
I have created a job that picks a datetime from Redshift and send that datetime to MySQL SP. My expected result was not achieved. Then I figured out that the datetime sent by component tMysqlSP is different from the datetime received at MySql Stored Procedure. I solved the issue as below.
Problem is :
Talend send DateTime, say 2016-15-01 04:28:09 to SP. But the SP receives 2016-15-01 00:00:00.
Solution:
I made Talend component to send String rather than DateTime, i.e., I sent "2016-15-01 04:28:09" rather than 2016-15-01 04:28:09.
