Snippet Name: Format numbers to two decimal places Description: Formatting numbers to two decimal places with mySQL. Comment: (none) Language: MYSQL Highlight Mode: MYSQL Last Modified: March 01st, 2009
Description: Formatting numbers to two decimal places with mySQL.
SELECT name, score, FORMAT(score,2) FROM games WHERE id <= 10