Six 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

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: Talend Date format issue

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

4 REPLIES
Six Stars

Re: Talend Date format issue

Hi meena,

What date pattern you have selected in tmap?

Thanks,
Lmit
Six 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.