Converting DATE to String and String to Integer in TMAP

[Rohitash]

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]

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

[Rohitash]

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]

Hello @Rohitash 

Please find the links below

http://talendhowto.com/2017/08/29/convert-between-different-datatypes/

https://www.oreilly.com/library/view/talend-open-studio/9781782167266/apa.html

[Rohitash]

Hi Abhishek,

I'm getting an java error. Please assist.

Please find attachment in the post.

Kindly reply.

Regards,

Rohitash 

ERROR_LOG.PNG

[Rohitash]

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]

Try Long 

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

If you want BigDecimal ,

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