Convert date to integer

One Star

Convert date to integer

Hi,
In tMap, I am mapping one date field to two different output tables. In one table it is expecting a date, in another table it is expecting an integer. So, I need to convert a date field into integer for the second table.
How do I do that?
Thanks,
Boris
One Star

Re: Convert date to integer

I was able to find a workaround for this, however, now I need to convert a String to BigDecimal and I am not able to do that.
What is the best way?
One Star

Re: Convert date to integer

Does anyone have a solution for me on converting String to BigDecimal?
Oracle expects a NUMBER in this column. And I have it as String in tMap.
I am mapping this same field to another column in another table as: TalendDate.parseDate("MM/dd/yyyy",row1.newColumn9)