Date format issue

Anonymous — Sat, 16 Nov 2024 03:48:09 GMT

Hi,

I am new to working on talend for the past 1 day.now am trying to read Exel file(.xlsx) to MySQL DB to stored.but am facing the date format issue, then how to store this format 12/16/2019 10:43 PM.

Re: Date format issue

Anonymous — Tue, 17 Dec 2019 16:54:38 GMT

Hi,

You will have to use Date data type with the format "MM/dd/yyyy HH:mm a". If the error persists, could you please share the tMap schema of the column where you are trying to load data. I would like to see both source and target.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

topic Re: Date format issue in Talend Studio

Date format issue

Re: Date format issue