I have a output table(mysql) which has a date field called syncdate format (YYYY-mm-dd hh:mm:ss) ex(2018-01-01 00:23:30). I need to load with date, whenever talend job runs. basically need to insert current date. In the tmap expression I have entered the defult function. The test result is coming correct as required but the job fails.
Kindly help in providing correct expression. Please check attached image for more details.
Solved! Go to Solution.
check the date format in mysql table ? and job is failling at tMsqloutput component right?
what is the error and please attahce the screenshot.
i do not findthe error in that screnshot.
I have used,its working for me check.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables