CEIL
Description
The Ceiling function returns the smallest integer greater than, or equal to, the specified numeric expression.
It can be applied to FLOAT columns or INT columns. The result is a column of type INT.
Syntax
CEIL ( table.column )
NULL handling
If the input value is NULL, the result is NULL as well.
Example
[1] CEIL of FLOAT input with one negative value and one NULL value: | ||||||||||||||||
| ||||||||||||||||
|
[2] CEIL has no effect on an INT column: | ||||||||||||||||
| ||||||||||||||||
|