Problem with format date and time in Metadata Excel File

[INESBK]

Hi,

I would like to read data from an excel file. Amongst the columns of this file, there are Date and Time columns that are filled using expression in the excel file.
Using talend and when I add a metadata File I get a preview at the beginning of these expressions as shown in Figure 1. And then a weird preview of the data formats in the Date and Time column as show in Figure2. 

How can I solve this problem especially that I need the date column format  be "dd/MM/yyyy" and the time column be "HH:mm:ss" ?

Thanks in advance for your help.

[INESBK · Accepted solution]

Hi,

I solved the problem using a routine to convert the date with code.

here is the solution : 

SimpleDateFormat sdf=new  SimpleDateFormat ("EEE MMM dd HH:mm:ss Z yyyy", Locale.ENGLISH);

return sdf.parse(d);