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.