topic Re: Converting date from one format to another format. in Talend Studio

Converting date from one format to another format.

Anonymous — Mon, 27 Jan 2014 07:19:18 GMT

Hi Experts,
I have date format: 01/09/2013 like this and it should be changed to like this 01-Sept-2013.
How can i achieve this?
Please provide me solution with Scenario.
With Regards,
Viswanath.Ch.

Re: Converting date from one format to another format.

Anonymous — Mon, 27 Jan 2014 07:32:26 GMT

Hi,
Is your input source data type "Date" or "String". If former, you can just change date format from "dd/MM/yyyy" to "dd-MMM-yyyy" in tMap.
See my screenshot
Best regards
Sabrina

Re: Converting date from one format to another format.

Anonymous — Mon, 27 Jan 2014 08:44:11 GMT

Hi Sabrina,
Thanks for reply.
With Regards,
Viswanath.Ch.

Re: Converting date from one format to another format.

Anonymous — Tue, 23 Aug 2016 10:51:26 GMT

Hi,
I have the same (to somw extent) situation, but:
tFileInputXML (date in YYYY-MM-DD format) -> tMap -> tFileOutputPositional (must be in DD-MM-YY)
Could you suggest the best way to do so?
If I just use the method described above the transformation becomes quite wierd: 2016-08-22 -> 361-12-16

Re: Converting date from one format to another format.

TRF — Tue, 23 Aug 2016 11:38:19 GMT

@akulkos, use the date pattern "yyyy-MM-dd" instead of "YYYY-MM-DD" (same for output, "dd-MM-yyyy").
Should work.
TRF

Re: Converting date from one format to another format.

Anonymous — Tue, 23 Aug 2016 12:03:19 GMT

Hello @akulkos,
you can also used anther component named 'tConvertType'.
Regards,
Jerry

Re: Converting date from one format to another format.

Anonymous — Fri, 01 Mar 2019 18:16:33 GMT

What if my input & output dates are strings?

I want to convert from "2019-01-10T06:35:00-04:00" to "20190110063500"(YYYYMMDDHHMMSS)