Date Conversion for Any format

Anonymous — Mon, 03 Jun 2019 21:52:38 GMT

Hi all,

I get dates which is in String with different format's(YYYYmmDD) and (MMddYYYY) etc.

I want to have the date value in string with only one format (YYYYmmDD).

How can i achieve it in the Tmap. assuming the column name as StartDateTime

Re: Date Conversion for Any format

Anonymous — Tue, 04 Jun 2019 03:44:19 GMT

Hi,

Could you please refer below link?

https://community.talend.com/t5/Design-and-Development/how-to-parse-various-date-formats/td-p/140825

Personally I do not agree allowing source systems to send the dates in whatever format they want especially in an enterprise environment. There should be agreed formats between various systems and if the format is not correct, it should be fixed at the starting point itself rather than changing in intermediate layer.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

topic Date Conversion for Any format in Talend Studio

Date Conversion for Any format

Re: Date Conversion for Any format