Michael Poppers (10/28/2009)
slange-862761 (10/28/2009)
Good point. The real deal is that the datatype was implicity set to have 4 decimal places and the round function will not change the datatype....Exactly. You can demonstrate this by, e.g., taking the last digit away from the round() call's 1st argument:
select round(3.567,1)will return a value rounded to three decimal places because the 1st argument is specified to three decimal places. Thanks.
But as someone else pointed out, the additional zeros can be mistaken for precision which is not good to have when you're rounding numbers.
If I told a manufacturer I needed a bolt .75 inches long, that's not as precise as telling them it needs to be .750000 inches. Without those zeros, they could make the bolt .7502 inches long and still be within specs. Rounding the number to one digit should not have such precision.