Talend Date format issue

[muralam]

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

[lmit]

Hi meena,

What date pattern you have selected in tmap?

Thanks,
Lmit

[muralam]

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

[Anonymous · Accepted solution]

hi its working fine please find the below attachments.

[Anonymous]

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.