Float values displays many

Legent Mady

9y1.1kSQL

i am using mssql,

my table columns

presented hours (float)

total hours (float)

percentage (float)

percentage displays 72.222267

how to display only 72.22

which data type to use?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sourabh Somani9y ago
1. select 76.77774443 as [Percent]
3. select convert(decimal(4,2),76.77774443) as [Percent]
:)

DECLARE @dd float='10.12345678'

SELECT

CONVERT(DECIMAL(10, 2), @dd)

String.Format("{0:0.00}", 72.222267); // "72.22"

double d = 72.222267; 
string s = d.ToString("F2"); 
 
Output: 72.22

Where you want to display? In UI or in database?

Try like this: FLOAT(4,2) as data type for percentage as PRECISION(4) and scale(2)