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

Seven Stars

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

Hi,

 

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


Accepted Solutions
Forteen Stars TRF
Forteen Stars

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

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

TRF

All Replies
Forteen Stars TRF
Forteen Stars

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

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.


TRF
Seven Stars

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

Hi @TRF,

 

Thank you.Working 

 

Forteen Stars TRF
Forteen Stars

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

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

TRF
Six Stars

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

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 

 

 

Ten Stars

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

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