SQL Reference

CEILING or CEIL

>>--+-CEILING-+---(--expression--)-----------------------------><
    '-CEIL----'
 

The schema is SYSFUN.

Returns the smallest integer value greater than or equal to the argument.

The argument can be of any built-in numeric type. If the argument is of type DECIMAL or REAL, it is converted to a double-precision floating-point number for processing by the function. If the argument is of type SMALLINT or INTEGER, the argument value is returned.

The result of the function is:

• SMALLINT if the argument is SMALLINT
• INTEGER if the argument is INTEGER
• BIGINT if the argument is BIGINT
• DOUBLE if the argument is DECIMAL, REAL or DOUBLE. Decimal values with more than 15 digits to the left of the decimal will not return the desired integer value due to loss of precision in the conversion to DOUBLE.

The result can be null; if the argument is null, the result is the null value.