I am creating a project in Talend Open Studio for Data Integration, in which I am getting an error while parsing the dates from the data source. The date is of “String” data type in the following format: 3/14/1967 0:00:00.
As per my research, I can see Talend is using java.text.SimpleDateFormat. I think SimpleDateFormat package handle the single-or-double digit problem. So, I am using “d-M-yyyy H:mm:ss” but still it gives me the following error: Unparsable date: 9/18/1994 0:00:00.
Can you suggest any solution for this or do I need to use a different date pattern?