Example
SELECT FORMAT(250500.5634, 2);Definition and Usage
The FORMAT() function formats a number to a format like "#,###,###.##", rounded to a specified number of decimal places, then it returns the result as a string.
Syntax
FORMAT(
number
,
decimal_places
)Parameter Values
| Parameter | Description |
|---|---|
| number | Required. The number to be formatted |
| decimal_places | Required. The number of decimal places for number. If this parameter is 0, this function returns a string with no decimal places |
Technical Details
| Works in: | From MySQL 4.0 |
|---|