topic Re: Unparseable date: "2019-11-11" Error in Talend Studio

Unparseable date: "2019-11-11" Error

desanip — Sat, 16 Nov 2024 02:30:09 GMT

Hello,

I am trying to convert the string value "2019-11-11" to Date format using the following expression:

row9.Date!=null && !row9.Date.equals(" ") ? TalendDate.parseDate("EEE MMM dd hh:mm:ss:zzz yyyy",row9.Date) : null

My target date format is "EEE MMM dd hh:mm:ss:zzz yyyy".

Can anyone tell me what i am doing wrong.

Re: Unparseable date: "2019-11-11" Error

billimmer — Wed, 06 May 2020 19:34:47 GMT

So is the target data type a string also? So first you have to convert to a date type with:

TalendDate.parseDate("yyyy-MM-dd",row9.Date)

And take that result and convert it to your out format. Do that with the 'formatDate' function:

TalendDate.formatDate("EEE MMM dd hh:mm:ss:zzz yyyy",TalendDate.parseDate("yyyy-MM-dd",row9.Date))

Re: Unparseable date: "2019-11-11" Error

desanip — Wed, 06 May 2020 19:40:21 GMT

The target data type is date with format EEE MMM dd hh:mm:ss:zzz yyyy

Re: Unparseable date: "2019-11-11" Error

desanip — Wed, 06 May 2020 20:12:44 GMT

@lliMy target data type is date in format "EEE MMM dd hh:mm:ss:zzz yyyy". When i try to use the expression you provided it throws a compilation error cannot convert from string to date.

I am using the following expression in my tmap:

row4.date!=null && !row4.date.equals(" ") ? TalendDate.formatDate("EEE MMM dd hh:mm:ss:zzz yyyy",TalendDate.parseDate("yyyy-MM-dd",row4.date)) : null

Re: Unparseable date: "2019-11-11" Error

billimmer — Wed, 06 May 2020 21:11:35 GMT

I tested this and it will work if the in data type is a String, and the out data type is a String. But that must not be the case.

If the in value or the out value, or both are date data types then you will get the error you mentioned.

What the expression currently does is convert a String to a Date, and then to a String again, in the format you specify.

Re: Unparseable date: "2019-11-11" Error

desanip — Thu, 07 May 2020 00:18:04 GMT

@lli Thank you.

Unfortunately, i have convert the string to date and the expression obviosuly doen't seem to work.

row4.date!=null && !row4.date.equals(" ") ? TalendDate.formatDate("EEE MMM dd hh:mm:ss:zzz yyyy",TalendDate.parseDate("yyyy-MM-dd",row4.date)) : null

Anyone has idea on how to fix this?

Re: Unparseable date: "2019-11-11" Error

desanip — Thu, 07 May 2020 12:23:44 GMT

Can someone please take a look and suggest me the solution?

Thanks again.

Re: Unparseable date: "2019-11-11" Error

billimmer — Thu, 07 May 2020 19:10:32 GMT

You are wrong. The code works. Test it as follows. Create a job with one tJava component.

In the tjava put your code:

String in = "2019-11-11";

String out = in!=null && !in.equals(" ") ? TalendDate.formatDate("EEE MMM dd hh:mm:ss:zzz yyyy",TalendDate.parseDate("yyyy-MM-dd",in)) : null;

System.out.println(out);

The output of the job is:

[statistics] connecting to socket on port 3897
[statistics] connected
Mon Nov 11 12:00:00:CST 2019
[statistics] disconnected

The problem is not with this code, it's with your schema.

EDIT: You need to adjust your schema to match your code OR adjust your code to match your schema. All the data types must match for this field, through all the steps of your job unless you specifically convert it to another data type at some point.