ROUND ( expression [, precision] )
expression- any valid numeric expression.precision- the number of digits after the decimal to round to. Rounds to the nearest long if the number of digits if not set.
Rounds to a number of digits, or to the nearest long if the number of digits if not set. This method returns a numeric (the same type as the input).
Converts every Player's age to an integer number:
SELECT name, ROUND(age) FROM Player;
Updated about 5 years ago