Six Stars

How to pass defult talend date to the output

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: How to pass defult talend date to the output

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.

Manohar B
9 REPLIES
Twelve Stars

Re: How to pass defult talend date to the output

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

Manohar B
Six Stars

Re: How to pass defult talend date to the output

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

Twelve Stars

Re: How to pass defult talend date to the output

what is the error and please attahce the screenshot.

Manohar B
Six Stars

Re: How to pass defult talend date to the output

PFA error details

Six Stars

Re: How to pass defult talend date to the output

One more screenshot

Twelve Stars

Re: How to pass defult talend date to the output

i do not findthe error in that screnshot.

Manohar B
Twelve Stars

Re: How to pass defult talend date to the output

I have used,its working for me check.

 

Manohar B
Twelve Stars

Re: How to pass defult talend date to the output

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.

Manohar B
Six Stars

Re: How to pass defult talend date to the output

Thanks a lot Manohar. It's working now.