top button
Flag Notify
Site Registration

Truncate decimal value but not round off the value in SQL Server?

+2 votes
342 views
Truncate decimal value but not round off the value in SQL Server?
posted Sep 2, 2014 by Muskan

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes
 
Best answer

use round something like
round(123.102, 2, 1) which will just truncate but will not round off.

Hope this helps.

answer Sep 2, 2014 by Salil Agrawal
...