Date values in String data type converts to different date format

mra802003 — Sat, 16 Nov 2024 03:17:06 GMT

Hi,

We have a source Excel file that has a field called “TERMDATE” that is formatted as “MM/DD/YYYY” as a String in the source file. It is also defined as a String in the Talend schema, and defined as a VARCHAR in the destination database. However, when it gets written to the database, it’s expanding the string to the following format:

Mon Jul 21 00:00:00 CDT 2014
Mon Feb 18 00:00:00 CST 2019
Sat Dec 01 00:00:00 CST 2018

Source values:

07/21/2014

02/18/2019

12/01/2018

How do we get Talend to maintain the “MM/DD/YYYY” format and preserve the String type from start to finish?

Regards,

Manish Anand

Re: Date values in String data type converts to different date format

mra802003 — Thu, 13 Feb 2020 19:12:51 GMT

Was able to resolve this myself.

topic Date values in String data type converts to different date format in Talend Studio

Date values in String data type converts to different date format

Re: Date values in String data type converts to different date format