I'm trying to read data from an excel file and I have a "date" column which has the "MM/DD/YYYY" format.
I need to put this data into MySQL, where the supported format is "YYYY-MM-DD"
How can I convert it? If I create a variable in tMap component, I've seen there is a "parseDate" function within "TalendDate" functions category. I think that's what need to use, but I cannot really understand how.
Posted on September 14, 2009 at 5:17am
With the TalendDate.parseDate() function you should be able to convert your date.
In your case it'll look something like:
Then in the output table you just enter "yyyy-MM-dd" format in the "Date Pattern" field.