topic Re: Datatype Conversion in Talend Studio

Datatype Conversion

Anonymous — Wed, 28 Mar 2012 21:53:44 GMT

Hello Talend Folks,
I am new to Talend and trying to accomplish some intermediate operations in TMAP Component. I need to convert the data types in TMAP to work through my tasks.
I need to convert from String - > Number ; String - > NVarchar2 ; String -> Timestamp ; String -> Date
Any help on the above is deeply appreciated.
Thanks
psreepa

Re: Datatype Conversion

Anonymous — Thu, 29 Mar 2012 04:03:52 GMT

Hi Psreepa
Welcome to Talend Community!
String->Number: String->Int
Integer.parseInt(s)
String->NVarchar2:
No need to change.
String->Timestamp and String->Date: String->Date
TalendDate.parseDate(pattern, stringDate)
Regards,
Pedro

Re: Datatype Conversion

Anonymous — Thu, 29 Mar 2012 15:19:12 GMT

Thanks for your quick response, Pedro.
I am getting an error after using TalendDate.parseDate("dd-mmm-yy",row2.Column0) . Do I also need to pick the date pattern? Source record is lik 2012-01-31 and my end result should look like 31-JAN-12.
Thx
Psreepa

Re: Datatype Conversion

Anonymous — Fri, 30 Mar 2012 03:03:10 GMT

Hi
You can change date pattern in tMap as the following image.
Regards,
Pedro