SQL Server - Round fn in Sql server 2008

Hi,

How to round this number 123.6789232 to 123.68 in sql server

Thanks.

Use this 

SELECT ROUND(@value, 2)


Regards

thats give the result as

123.68000

but i want the result to be 123.68

Here is it

Declare @invTax Money
SET @invTax=123.6789232
select convert(decimal(12,2),@invTax)

Output

123.68

you should not use ROUND in this case, if we use round number of decimal places will be same as original number, for eg

number 2.65865, if we round this ->  ROUND(2.65865,2)  output will be 2.66000

so use convert like this way
select convert(decimal(12,2),2.65865)
O/P -> 2.66

Hello,

Try following way

 

SELECT CAST(ROUND(123.4567, 2) AS MONEY)

SELECT CONVERT(Money,ROUND(123.4567,2))

 

SELECT CONVERT(DECIMAL(25,2),ROUND(123.4567,2))

SELECT CAST(ROUND(123.4567, 2) AS Decimal(25,2))

 

 

Hope this is helpful !

Thanks

 

 

 

 

 

select convert(decimal(18,2),round(123.6789232,2))

select cast(123.6789232 as numeric(18,2)) as value

select cast(123.6789232 as decimal(18,2)) as value