Unparseable date: "22-May-2017 19:07:00"

[Anonymous]

Hi,

Can anyone say what is the correct format for  "22-May-2017 19:07:00"

[TRF]

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.

[Anonymous]

Hi @TRF,

Thank you.Working 

[TRF · Accepted solution]

@Sara, great!
Don't forget to mark this topic as solved

[Romanesku]

Hi,

I have similar problem with parsing date from csv. My function in tMap look like

TalendDate.parseDate("[dd/MMM/yyyy:HH:mm:ss.SSS]",row7.fulltime )

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?

Thank you.

Roman 

[cterenzi]

This topic is both old and solved. If you want attention to your issue, start a new topic.