CEIL

All functions > MATH > CEIL

Rounds a number up to the nearest integer (ceiling function).

Syntax

CEIL(expr)
sql

Arguments

ParameterTypeRequiredDescription
numberDOUBLEYesThe number to round up

Returns

BIGINT - Integer result of rounding up

Notes

  • Always rounds towards positive infinity
  • CEIL(2.1) = 3, CEIL(2.9) = 3
  • CEIL(-2.1) = -2, CEIL(-2.9) = -2
  • Returns NULL if the input is NULL
  • For exact integers, returns the same value

Examples

Suggest changes to this page
Last update at: 2025/10/13 10:23:46