topic Re: Date error in Talend Studio

Date error

Anonymous — Wed, 24 Apr 2019 11:53:21 GMT

Hi everybody!

I'm having problems with inserting data in the date field.

I receive the data of an Excel and I have a column that has some dates, when I do in the TMap the parseDate I get the following error:
Unparseable date: "25/09/2014"

I have this data entry: "25/09/2014"

And in database, it is saved like this:
2015-12-01T17: 35: 17.55Z

I have tried with the solutions that I have found in this forum, but I have not had any luck. Can you help me?

Thank you!

Attached pictures of tMap!

regards!

Re: Date error

manodwhb — Wed, 24 Apr 2019 12:14:22 GMT

@LLBetween ,try with below format.it should work.

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ssZ",row1.col)

Re: Date error

Anonymous — Wed, 24 Apr 2019 12:25:24 GMT

Thanks for your quick response.

The error keeps appearing: java.lang.RuntimeException: java.text.ParseException: Unparseable date: "25/09/2014"

I have to change a component or something in the Data Patter of tMap?

Thanks!

Re: Date error

manodwhb — Wed, 24 Apr 2019 12:29:06 GMT

@LLBetween ,try with below one.

TalendDate.parseDate("dd/MM/yyyy",row1.col)

Re: Date error

Anonymous — Wed, 24 Apr 2019 13:37:08 GMT

Thanks for your reply!

Now I do not see the error, but it does not insert the data in the database.

In Database the field I need to be inserted like this: 2017-05-19T15:35:29.667Z

This message appears: | The field [salesForecastDate] is other type (3)

Re: Date error

manodwhb — Wed, 24 Apr 2019 18:09:08 GMT

@LLBetween , now in tmap output section of the field date format specify the below one.

"yyyy-MM-dd'T'HH:mm:ss Z"

Re: Date error

Anonymous — Mon, 29 Apr 2019 09:57:03 GMT

Thanks for you reply!

I solved the problem with this code: "yyyy-MM-dd'T'HH:mm:ss'Z'" if i don't put 'Z' i can't insert into SQL Server.

I hope this can help someone with the same problem.

Regards!

Re: Date error

manodwhb — Mon, 29 Apr 2019 12:51:27 GMT

@LLBetween , I gave the solution,which you should mark as a solution.

Re: Date error

Anonymous — Mon, 29 Apr 2019 13:17:03 GMT

Do it!