CODEWITHSUNDEEP
sqlsql-serversql-server-2008ssmsrounding
Shweta Reddy
Shweta Reddy

Reputation: 371

SQL : Round off to 1 decimal Point

I am trying to round my value to one decimal, below is sample which I tried.

INPUT     DESIRED OUTPUT
129.700   129.7
129.769   129.8

I have tried

SELECT CAST(ROUND(('129.768'),0) AS DECIMAL(10,1))
FROM Table1

is not giving correct value.

Please help.

Upvotes: 0

Views: 982

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269853

You want one digit after the decimal place, so that would be an argument of 1, not 0:

SELECT CAST(ROUND('129.768', 1) AS DECIMAL(10, 1))

I'm not sure why you feel the need to convert back to a decimal -- unless you are saving the value to a table and want to control the type. This also does what you want:

SELECT ROUND('129.768', 1)

Upvotes: 1

Related Questions