Happy Business Starts Here

How to Convert price from OE-9(bigdecimal) to 0.00 Integer

Highlighted
Zuora Alumni

How to Convert price from OE-9(bigdecimal) to 0.00 Integer

When we are using Data Query to fetch the rate plan charge price there is a possibility that price value may display in Bigdecimal, so in order to convert it from Bigdecimal to integer we can use the following code 

 

substr(cast(rpct.price as varchar),1,strpos(cast(rpct.price as varchar),'.')+3)