Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
You no need to use "TalendDate.getCurrentDate() " exactly and on the output coulmn date format speciy in "YYYY-mm-dd hh:mm:ss" and it works.
check the date format in mysql table ? and job is failling at tMsqloutput component right?
`SyncedDate` datetime DEFAULT NULL my output, Job failing in tmap
what is the error and please attahce the screenshot.
i do not findthe error in that screnshot.
You no need to use "TalendDate.getCurrentDate() " exactly and on the output coulmn date format speciy in "YYYY-mm-dd hh:mm:ss" and it works.
Thanks a lot Manohar. It's working now.