How to use ROUNDDOWN in sqlserver

Question

I want to use ROUNDDOWN function.

When i tried using the following query,it gives me an error saying "'rounddown' is not a recognized built-in function name."

select rounddown(25.227,2)

My requirement is to rounddown the value to two decimals

for ex: for value 25.22789 result should be 25.22

and round up also

for ex: for value 25.22789 result should be 25.23

Any help?

Thanks in advance

Answer 1

Use third parameter of ROUND() function to truncate and then CONVERT() it to DECIMAL(x, 2) to get rid of unwanted trailing zeros.

Fiddle demo

SELECT CONVERT(DECIMAL(10,2), ROUND(25.227, 2, 1)) RoundDown,
        CONVERT(DECIMAL(10,2), ROUND(25.227, 2, 0)) RoundUp

Results

| RoundDown | RoundUp |
|-----------|---------|
|     25.22 |   25.23 |

Answer 2

I think you are looking for either CEILING() or floor() function like

select CEILING(25.227) //results in 26

(OR)

select FLOOR(25.227) //Results in 25

EDIT:

for ex: for value 25.22789 result should be 25.22

You can try like below

select round(25.22789, 2, 2)

Which will result in 25.22000