Rounding decimal in sql server

Question

Is it possible to round downward with SQL server 2008? E.g. .96855 is rounded to .968.

I.e. up to .96899 I want to round .96899 by avoiding rest.

Answer 1

SELECT round(0.96855, 3, 1)

-> 0.96800

For 0.968 : cast(round(0.96855, 3, 1) as decimal(10,3)) works fine.

Ref: Round (if last param to Round is anything other than zero, it truncates)

Answer 2

cast(round(0.96855, 3, 1) as decimal(10,3))

Answer 3

Could this help?

SELECT ROUND(123.9994, 3)    
Results: 123.9990  


SELECT ROUND(123.9995, 3)    
Results: 124.0000