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.