MYSQL - Fetch proper float values

Question

I am changed data-type of 1 table field int to float for accept decimal values also

i am saving value as 0.05, 0.1

when i am fetching value with following query:

SELECT points from tbl_points where user_id=10

it returns me vaule like

0.0546565749

i am not getting why this is happening. i just want to display value as it saved to into table. i.e. 0.05 OR 0.1

please help me....

thanks in advance

What is the insert query you used ? And you can use the ROUND function. — DhruvPathak
– DhruvPathak, Commented Feb 11, 2014 at 5:40
@Vickey, not it does not, try SELECT ROUND(0.0546565749,2); — DhruvPathak
– DhruvPathak, Commented Feb 11, 2014 at 5:44

Nagaraj S · Accepted Answer · 2014-02-11 05:43:12Z

1

You need to change your float to 2 decimal places i.e. float(10,2)

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

answered Feb 11, 2014 at 5:41

Vikas Umrao

2,5801 gold badge17 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vikas Gautam · Accepted Answer · 2014-02-11 05:44:38Z

0

$tt = "105";
echo number_format((float)$tt, 2, '.', '');  // this will  output  105.00

answered Feb 11, 2014 at 5:44

Vikas Gautam

9788 silver badges25 bronze badges