asked
How to convert a decimal to the nearest quarter?
How do I convert a decimal to the nearest 1/4th? For ex: 0.3 ------ 0.25 10.85 ---- 10.75 85.9 ----- 86.00
You could multiply the value by four, then round it to zero decimals, divide that value by four and finally cast it to two decimals. Like this: DECLARE @n decimal(10,4) = '20.7531'; SELECT CAST( ROUND(@n * 4,0) / 4 AS decimal(8,2));
16 People are following this question.
