How to skip rounding the number in sql server

Question

Question by hotchap · Jan 21, 2019 at 12:57 PM · sql server sql server 2008

Hi All

DECLARE@count NUMERIC(8, 2) 
set @count = 165.165 
print @count

Result is giving '165.17' where as i need '165.16'

it should not round of the number

please help

0

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-01-21T13:06:51Z

Answer by Kev Riley · Jan 21, 2019 at 01:06 PM

You need to explicitly truncate the number using the 3rd argument in the ROUND() function

declare @count NUMERIC(8, 2) 
set @count = round(165.165,2,1)
print @count

165.16

2 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.