Date values in String data type converts to different date format

[mra802003]

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

[mra802003 · Accepted solution]

Was able to resolve this myself.