Loading lesson path
Concept visual
Start at both ends
Format the number as "#,###,###.##" (and round with two decimal places):
SELECT FORMAT(250500.5634, 2);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.
number, decimal_places )
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
From MySQL 4.0
Format the number as a format of "#,###,###.##" (and round with 0 decimal places):
SELECT FORMAT(250500.5634, 0);❮ MySQL Functions