topic Converting DATE to String and String to Integer in TMAP in Talend Studio

Converting DATE to String and String to Integer in TMAP

Rohitash — Wed, 24 Apr 2019 15:34:07 GMT

Hi All,

I have a small requirement, where multiple conversion is required

Scenario

I have date field name X_DT and it's Datatype is DATE and on the other end it has NUMBER Datatype. So how to convert it ?

First conversion should be on STRING Datatype and then it should converted into INTEGER Datatype.

Kindly assist.

Regards,

Rohitash Sherigar

akumar2301 — Wed, 24 Apr 2019 16:18:21 GMT

Integer.valueOf(TalendDate.formatDate("yyyyMMdd", row1.datecolumn))

Rohitash — Wed, 24 Apr 2019 16:44:48 GMT

Thanks Abhishek for the assistant.

It's worked out really.

Could you please share the link of this function to write.Where I can reference it or future.

Anonymous — Wed, 24 Apr 2019 18:47:35 GMT

Please find the links below

Rohitash — Thu, 25 Apr 2019 08:44:29 GMT

Hi Abhishek,

I'm getting an java error. Please assist.

Please find attachment in the post.

Kindly reply.

Regards,

Rohitash

Rohitash — Thu, 25 Apr 2019 08:51:19 GMT

Hi Abhishek,

As discussed my date format is in this form

DATE FORMAT : "yyyyMMddHHmmssSSS"

First i have to convert into string and then into number format.

So please suggest which datatype is suitable?

Float,Double, Integer or BigDecimal.

Please share the expression.

akumar2301 — Thu, 25 Apr 2019 09:07:09 GMT

Try Long

Long.valueOf(TalendDate.formatDate("yyyyMMddHHmmssSSS", new Date()))

If you want BigDecimal ,

new BigDecimal(TalendDate.formatDate("yyyyMMddHHmmssSSS", new Date()))