Talend Date format issue

Highlighted
Seven Stars

Talend Date format issue

Hi,

 

for couple of columns i want date format like below

col1: dd-MMM(14-Feb)

col2:dd-MMM-yyyy(12-Feb-2018)

i changed the date pattern at tmap but still for all the columns am getting output as 19-SEP-18  (sample format) both from source DB and Target DB columns are Datatype DATE

 

Regards,

Meena


Accepted Solutions
Six Stars

Re: Talend Date format issue

hi its working fine please find the below attachments.Capture3.PNGCapture4.PNG


All Replies
Seven Stars

Re: Talend Date format issue

Hi meena,

What date pattern you have selected in tmap?

Thanks,
Lmit
Seven Stars

Re: Talend Date format issue

I gave the pattern as dd-MMM for one column and dd-MMM-yyyy for one column
Six Stars

Re: Talend Date format issue

hi its working fine please find the below attachments.Capture3.PNGCapture4.PNG

Five Stars

Re: Talend Date format issue

If the input data type is not of type date then try parsing it to date first in tmap and then specify the date format in which you want your data.

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog