Jose Saiz

Jose Saiz

  • 1.4k
  • 235
  • 97.8k

How to Convert numeric data type with 1 digit decimal

Jul 9 2018 6:50 PM
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)