• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • CEILING()
  • FLOOR()
  • FORMAT()
  • HEX()
  • OCT()
  • RAND()
  • ROUND()
  • UNHEX()

ROUND()

Return the value of the evaluated expression rounded up to the nearest integer.

Prototype

integer ROUND(expression expression, integer places = 0)

Parameters

• expression - Expression that should evaluate to an integer or decimal number.
• places - Optional number of decimal places to round to (default is zero).

Return

Value of the evaluated expression rounded up to the nearest integer.

Example

SELECT OID, Date, ROUND(Total,2) AS RoundedTotal FROM Invoice

Related

CEIL(), FLOOR()

• < RAND()
• UNHEX() >