Parsing Date Error in Talend

Question

I have an excel file that contains data in the date format but it's of “String” data type. I need to upload this data into a database but before that, I need to cast the date from “String” to “Date” data type. I tried using tConvertType to perform this. But it is throwing an error saying:

java.text.ParseException: Unparseable date: "Tue Jul 17 00:00:00 EDT 1973"

Can someone point out what I am doing wrong?

Below is the screenshot of my job:

Answer 1

This job doesn’t needs tConvertType. You can easily perform the conversion or casting of data type from within the tMap component's Expression Builder. All you need is the correct expression to give the a correct date format. You can try using the below expression in your tMap:

input_DateColumn!=null && !"".equalsIgnoreCase(input_DateColumn)? TalendDate.parseDateLocale("EEE MMM dd HH:mm:ss zzz yyyy", input_DateColumn, "EN") :null

Hope this was what you were looking for. 

Get your Talend certification today to become certified professional.

Thanks.