Date values in String data type converts to different date format
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?
