Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-12-17 10:36 AM

Date format issue

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.

 

 

 

 

Labels (3)
Labels
69 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-12-17 11:54 AM
Author

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

69 Views
0 Likes