cengland0 (10/28/2009)

---

Don't they realize 3.6 and 3.6000 is the same value and it's more proper to delete the extra zeros?

slange-862761 (10/28/2009)

---

Not sure I agree that it is more "proper". Depending on what the number represents you may want to know that it was calculated at some precision. For example if you were measuring the clearance of a piston to the cylinder it would be more "proper" to say 3.6000 instead of 3.6. As with everything these types of things need to be suited to the task at hand. Just my 2 cents.

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....

select round(3.567,1)

Michael Poppers (10/28/2009)

---

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.

cengland0 (10/28/2009)

---

Also, if I'm rounding a number, I'm trying to reduce the number of digits after the decimal. If it keeps the same number of digits, why round it?

Good example:

Select 123.45 * 1.07

This is how much tax @ 7% to charge a customer and then add the original 123.45 back in. The answer is 132.0915. Now if I need to round that number, I would expect the final dollar amount to be 132.09.

 select round(123.45 * 1.07,2)

This results in 132.0900 -- a little confusing if I'm going to be generating a report showing total sales after tax.

Anyone have a good solution to get the 132.09 as a result of a simple formula?

SELECT CAST(ROUND(123.45 * 1.07,2) AS numeric(9, 2))