Views: 13.9K
Replies: 1
Archived
|
SQL Server: How do I truncate (not round) decimal places?I am writing a stored procedure in SQL Server 2008 R2.
I am struggling with rounding / truncating a decimal value. For example the value 9.567 gets rounded up to 9.57, but that is not what I need. In my situation I just need to truncate (chop off) the last digit. The desirable value is 9.56. How do I do this? Craig Johnston, Feb 23, 2013
|
|
Reply 1select Convert(varchar,Floor(9.567))+'.'+Substring(Convert(varchar,9.567-Floor(9.567)),3,2)
You can create this as a function and call any where in the your stored procedure Yogesh Rajput, Sep 05, 2013
|