[resolved] Unparseable Date with date format dd-Mon-yyyy

[Anonymous]

Hello,
This might be stupid but I am struggling with this issue for 2 hours now.
csv file contains
Date, Bid, Offer, Mid
10-Apr-2014, 21.400, 21.450, 21.4250
and I am trying to load the date into a PostgresQL date column to have "2014-04-10"
whatever talend parse date pattern I use I keep on having this exception !!!

Exception in component tMap_1
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "10-Apr-2014"
at routines.TalendDate.parseDate(TalendDate.java:836)
at nitrofer.load_dayahead_0_1.Load_DayAhead.tFileInputDelimited_1Process(Load_DayAhead.java:2156)
at nitrofer.load_dayahead_0_1.Load_DayAhead.tFileList_1Process(Load_DayAhead.java:1126)
at nitrofer.load_dayahead_0_1.Load_DayAhead.tFileInputProperties_1Process(Load_DayAhead.java:515)
at nitrofer.load_dayahead_0_1.Load_DayAhead.runJobInTOS(Load_DayAhead.java:3030)
at nitrofer.load_dayahead_0_1.Load_DayAhead.main(Load_DayAhead.java:2862)
Caused by: java.text.ParseException: Unparseable date: "10-Apr-2014"
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:822)
... 5 more
So please any ideas to have this solved ?
Thanks,
LR

[Anonymous]

Need to change date containing milliseconds to seconds, truncating milliseconds data without upcasting. Have used the formula 
(row2.START_DATE==null || row2.START_DATE.isEmpty())? null : TalendDate.parseDate("yyyy/MM/dd'T'hh:mm:ss",TalendDate.formatDate("dd/MM/yyyyhh:mm:ss",TalendDate.parseDate("yyyy/MM/dd'T'hh:mm:ss",row2.START_DATE)))  in the tmap component.
But, it is showing the following error..
Caused by: java.text.ParseException: Unparseable date: "2015-06-12T20:40:07"

[Anonymous · Accepted solution]

Thank you, done somehow. have used tbufferinput in middle, got the output