5
Answers

How to Convert numeric data type with 1 digit decimal

Jose Saiz

Jose Saiz

6y
678
1
How to add to a numeric data type with 1 digit decimal a zero.
For Instance
Assuming that I got a result from a calculation 7.7 which means 7.07, how to add the leading zero or how to convert to a 2 decimal points
 
The ROUND() rounds it to 7.70 and or 8.0 and what I am looking for to be 2 decimal points with the leading zero, in other word the result should be 7.07
 
I will really appriciates for sample code that converts from 7.7 to 7.07
 
Thanks 
Jose 
 
Answers (5)