Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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
Labels (4)
11 Replies
Anonymous
Not applicable
Author

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
Not applicable
Author

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