ROUND

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