topic Re: How to convert Dates to YYYYMMDD" format in Talend Studio

How to convert Dates to YYYYMMDD" format

Mitz — Fri, 15 Nov 2024 22:25:58 GMT

Hi,

I would like to get some help on the issue I am trying to fix.

I am using the tMap component and trying to convert the date value of a column from "yyyy-MM-dd'T'HH:mm:ss'.000Z'" to "yyyymmdd" date format. I tried to use the syntax below but it won't work.

TalendDate.formatDate("yyyymmdd",row1.DateStamp)

I even changed the Data Type to String in the tMap Output still it won't work.

If I forced the required format ("yyyymmdd") in the "Date Pattern" field in tMap it was giving me an incorrect value such as "20213912" instead of "20220612".

Do you have any idea on this how to fix it?

Thank you much in advance.

Re: How to convert Dates to YYYYMMDD" format

Anonymous — Mon, 24 Oct 2022 01:25:12 GMT

Hello,

in the tMap output, you can setup the column value to TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",row1.DateStamp ) , the column type to 'Date' with Date pattern: "yyyyMMdd" as the below

Re: How to convert Dates to YYYYMMDD" format

Mitz — Mon, 24 Oct 2022 04:24:30 GMT

Thank you so much, Achen.

I tried to apply your solution but, I got the error below.

Re: How to convert Dates to YYYYMMDD" format

Anonymous — Mon, 24 Oct 2022 06:20:26 GMT

Hello Mitz,

Regarding to your above error, seems the input column type is 'Date'? if yes, please setup the tMap output value to row1.DateStamp as the below

Re: How to convert Dates to YYYYMMDD" format

Mitz — Wed, 26 Oct 2022 06:32:02 GMT

Thanks Achen.

It works now. Thanks for your help. 👍