topic Re: Convert int to bigdecimal tMap in Talend Studio

Convert int to bigdecimal tMap

_AnonymousUser — Wed, 24 Jul 2013 08:30:13 GMT

Hi,
Im trying to calculate how large of the percentage of a month that has already gone by.
I've tried to do it like this:
java.util.Calendar.getInstance().get(java.util.Calendar.DATE) / java.util.Calendar.getInstance().getMaximum(java.util.Calendar.DAY_OF_MONTH);
The calculation seems to work, but it is type integer, so the result is wrong. How can I get it to be a decimal figure?

Re: Convert int to bigdecimal tMap

Anonymous — Tue, 30 Jul 2013 05:00:37 GMT

Hi,
Could you convert int->BigDecimal using

java.math.BigDecimal()

Best regards
Sabrina

Re: Convert int to bigdecimal tMap

djugal — Tue, 30 Jul 2013 06:12:29 GMT

just use tconverttype for all the conversions its very useful
Thanks & Regards,
djugal

Re: Convert int to bigdecimal tMap

Anonymous — Tue, 30 Jul 2013 11:30:38 GMT

tconverttype is missing a lot of needed conversions. E.g. BigDecimal -> Integer or Long.
Unfortunately the BigDecimal type will be used much to often even if Integer is quite enough.

Re: Convert int to bigdecimal tMap

alevy — Wed, 31 Jul 2013 11:02:42 GMT

tConvertType happily converts BigDecimal to Integer or Long but that won't solve your problem. You need to have the numerator as a non-Integer before the division so use:
((Integer)java.util.Calendar.getInstance().get(java.util.Calendar.DATE)).doubleValue() / java.util.Calendar.getInstance().getMaximum(java.util.Calendar.DAY_OF_MONTH)