Hi All,
What is mean by rtype in Type Conversion Function
StringToDecimal(%string%,[%rtype%])??
suppose my input is sal=126540 and i need output like 126540.00
Can Anybody Explain with Example ???
Thanks,
Rajneesh.
String to Decimal Conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Fri Nov 18, 2011 3:19 am
- Location: Delhi
Rounding type. It is documented here: http://publib.boulder.ibm.com/infocente ... 0%65%22%20
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 6
- Joined: Fri Nov 18, 2011 3:19 am
- Location: Delhi
Re: String to Decimal Conversion
Thanks jwiles,
I Practiced and found the answer of my Query .
Conversion should be Like Below :
StringToDecimal(<Input Column>,'2').
2 is the Precision Place in case of Decimal, but in String Format.
Thanks :D ,
Rajneesh.
I Practiced and found the answer of my Query .
Conversion should be Like Below :
StringToDecimal(<Input Column>,'2').
2 is the Precision Place in case of Decimal, but in String Format.
Thanks :D ,
Rajneesh.