topic Re: Unparseable date - Convert JSON string to Date in Talend Studio

Unparseable date - Convert JSON string to Date

Edith1 — Thu, 07 May 2020 00:28:22 GMT

I'm trying to convert a string field from tExtractJSONFields to a date.

The expression in tMap is TalendDate.parseDate("yyyy-MM-dd hh:mm:ss",row4.Date).

Here is the error:

Caused by: java.text.ParseException: Unparseable date: "["2020-03-09 15:21:53"]"

The output column is DATE type, formatted "yyyy-MM-dd HH:mm:ss".

Please Help!

Re: Unparseable date - Convert JSON string to Date

manodwhb — Thu, 07 May 2020 04:58:30 GMT

@EdithM , the below expression working well. you need to check expression and data types of the target once.

TalendDate.parseDate("yyyy-MM-dd hh:mm:ss",row4.Date)

Re: Unparseable date - Convert JSON string to Date

Edith1 — Thu, 07 May 2020 16:50:37 GMT

Thanks for the reply @manodwhb. The expression is the same and the target data type is Date and date pattern is "yyyy-MM-dd HH:mm:ss". I am still getting the same unparsable date error.

I did a test where I changed the target field as string and removed the expression. It's logging as ["2020-03-26 15:30:55"]

Do I need to replace the brackets and double quotes before the expression TalendDate.parseDate("yyyy-MM-dd hh:mm:ss",row4.Date)?

Re: Unparseable date - Convert JSON string to Date

manodwhb — Fri, 08 May 2020 04:56:44 GMT

@EdithM , yes you need to remove [" and ]" ,and then convert it will work.