Depends of what you expect for september (for example):
- "dd-MMM-yyyy HH:mm:ss" will give you "22-May-2017 19:07:00" but "22-Sept.-2017 19:07:00"
- "dd-MMMM-yyyy HH:mm:ss" will give you "22-May-2017 19:07:00" but "22-September-2017 19:07:00"
Hope this helps.
I have similar problem with parsing date from csv. My function in tMap look like
when this job runs in mounts ago: April, March , with values like [01/Apr/2018:00:00:09.236]
everything works well, but from May I have problem for example value [01/May/2018:00:00:09.236] return an exception
Exception in component tMap_1 (TestMayError)
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "[07/May/2018:00:00:09.236]"
Do you have idea what should be wrong?