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

CEIL()

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

Prototype

integer CEIL(expression expression)

Parameter

• expression - Expression that should evaluate to an integer or decimal number.

Return

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

Example

SELECT OID, Date, CEIL(Total) AS RoundedTotal FROM Invoice

Related

FLOOR(), ROUND()

• < ABS()
• CEILING() >