top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

+2 votes
93 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...