Talend Date format issue

Highlighted
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
Highlighted
Six Stars

Re: Talend Date format issue

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

View solution in original post


All Replies
Highlighted
Seven Stars

Re: Talend Date format issue

Hi meena,

What date pattern you have selected in tmap?

Thanks,
Lmit
Highlighted
Seven Stars

Re: Talend Date format issue

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

Re: Talend Date format issue

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

View solution in original post

Highlighted
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 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog