tsql - T-SQL - how to round DOWN to nearest .05 -
The database I am using is SQL Server 2005. I am trying to fill the values in the nearest value .05 (nickel). So far I have: SELECT ROUND (number to turner / 5, 2) * 5 Which To evaluate approximately 1.95 , 2 , No, 1.99 / Strong>. Specify the non-zero values for the third parameter instead of the triangle: SELECT ROUND (numberToBeRounded / 5, 2, 1) * 5 Note: Going from zero to side towards zero, but it only makes a difference if You can use the floor function to round negative values, but you can not specify the number of decimals. So that you should multiply instead of dividing: SELECT FLOOR (number ToBeRounded * 20) / 20