topic Re: Talend Date format issue in Talend Studio

Talend Date format issue

muralam — Wed, 14 Mar 2018 16:40:11 GMT

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

Re: Talend Date format issue

lmit — Wed, 14 Mar 2018 16:53:35 GMT

Hi meena,

What date pattern you have selected in tmap?

Thanks,
Lmit

Re: Talend Date format issue

muralam — Thu, 15 Mar 2018 06:54:13 GMT

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

Re: Talend Date format issue

Anonymous — Thu, 15 Mar 2018 08:35:11 GMT

hi its working fine please find the below attachments.

Re: Talend Date format issue

Anonymous — Fri, 16 Mar 2018 09:46:47 GMT

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.