Kettle - JSON Input fail on unparseable date

0
votes

I'm trying to parse a date field "Wed 9-16-15 14:50:13 CDT" using "EEE M-d-yy HH:mm:ss zzz" yet I'm getting unparseable date. I'm using all the correct symbols according to the pentaho site.

1
jsondateparsingpentahokettle
kettle is written on java, so u should look into JavaAPI to find out how to parse date using java.text.SimpleDateFormat (docs.oracle.com/javase/7/docs/api/java/text/…) – simar

1 Answers

1
votes

I succeseed to solve problem. You just have to set locale. Another thing set lenient to false ('N') enter image description here

Information is taken from here http://forums.pentaho.com/showthread.php?160099-Cannot-parse-date-in-string-to-date-format