CEIL
Syntax
<ceil-expression> := 'CEIL(' <Number> ')'
Since
2.0
Return-type
Integer
Description
Returns the smallest (closest to negative infinity) integer that is not less than the argument. Special cases:
- If the argument value is of the type integer, then the result is the same as the argument.
- If the argument is NULL, then the result is also NULL.
Examples
CEIL( 1.5 )
= 2
CEIL( -1.5 )
= -1
CEIL( 5 )
= 5
CEIL( NULL )
= NULL
See also
FIRST, ROUND
