How to pass defult talend date to the output

[DM2017]

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.

[manodwhb]

 check the date format in mysql table ? and job is failling at tMsqloutput component right?

[DM2017]

`SyncedDate` datetime DEFAULT NULL my output, Job failing in tmap

[manodwhb]

what is the error and please attahce the screenshot.

[DM2017]

PFA error details

Capture1.JPG

[DM2017]

One more screenshot

Capture.JPG

[manodwhb]

i do not findthe error in that screnshot.

[manodwhb]

I have used,its working for me check.

Untitled.png

[manodwhb · Accepted solution]

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.

[DM2017]

Thanks a lot Manohar. It's working now.