MySQL ROUND() function|Mysql Format number to 2 decimal places|Show two decimal places in particular column.

Try round function:

Syntax:

ROUND(number, decimal_places);

Name Description
N - A number which will be rounded upto D decimal places.
D - A number indicating up to how many decimal places N will be rounded.

Normal Query:

SELECT '786.6579'

Result:

Rounded Query:

SELECT round('786.6579',2)

Result: