Change number format

How can I change number format?

I want to change number 3.4893 to 2 dight only until become 3.49

if you're printing it:

PHP Code:

---

printf("%.2f", $number); 


---

if you're just using it internally for calculations...

PHP Code:

---

sprintf("%.2f", $number); 


---

or check out the number_format function

If you are using it for a MySQL query, use FORMAT():

Quote:

---

FORMAT(X,D)
Formats the number X to a format like '#,###,###.##', rounded to D decimals. If D is 0, the result will have no decimal point or fractional part:
mysql> SELECT FORMAT(12332.123456, 4);
-> '12,332.1235'
mysql> SELECT FORMAT(12332.1,4);
-> '12,332.1000'
mysql> SELECT FORMAT(12332.2,0);
-> '12,332'

---