MySQL FORMAT() Function

Example

Format the number as "#,###,###.##" (and round with two decimal places):

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

More Examples

Example

Format the number as a format of "#,###,###.##" (and round with 0 decimal places):

SELECT FORMAT(250500.5634, 0);

Try it Yourself »

❮ Previous ❮ MySQL Functions Next ❯