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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

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