CEILING
The CEILING function returns the smallest integer that is greater than or equal to the input argument.
Syntax
CEILING (argument)
Remarks
The table lists the valid input argument data types and the resulting output data types.
Data Type of Argument | Output Type |
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT | INTEGER |
NULL | NULL |
Examples
SELECT CEILING (3598.6);
The result is 3599.
SELECT CEILING (-3598.6);
The result is -3598.