String to Decimal conversion

srini.dw · Post by **srini.dw** » Fri Mar 29, 2013 10:44 am

Source file has varchar2(20) but target table has Decimal(20,6).How to convert varchar2 to decimal.i tried using StringToDecimal() function.But output coming as all ZERO's.Target values as 00000000000000.000000

Please suggest your thoughts on this ....

chulett · Post by **chulett** » Fri Mar 29, 2013 10:52 am

You use the StringToDecimal() function. Show us your syntax and some samples of the incoming data. Also, are you saying that you always get zeroes regardless of the original string value?

srini.dw · Post by **srini.dw** » Sat Mar 30, 2013 12:03 am

Using function as StringToDecimal(lkGeidAdded.OVERRIDE_BALANCE_UNITS,6)

Input values 20.5 , 5.5.....but output coming as 00000000000000.000000

jwiles · Post by **jwiles** » Sat Mar 30, 2013 10:12 am

StringToDecimal(lkGeidAdded.OVERRIDE_BALANCE_UNITS,6)

Why do you include ",6" in your StringToDecimal() function call? This optional second parameter of the function is a string which indicates the type of rounding to be performed during the conversion, as documented here. This may likely be the cause of your problem.

Regards,