Talend Date format issue

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 Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads