<< CAST() | FB 2.5 Language Reference | CHAR_LENGTH(), CHARACTER_LENGTH() >>
<< CAST() | FB 2.1 Language Reference | CHAR_LENGTH(), CHARACTER_LENGTH() >>

CEIL(), CEILING()

Available in: DSQL, PSQL

Added in: 2.1

Description

Returns the smallest whole number that is greater than or equal to the argument.

Result type: BIGINT or DOUBLE PRECISION

Syntax

 CEIL[ING] (number)

Important: If the external function CEILING is declared in your database, it will override the internal function CEILING (but not CEIL). To make the internal function available, DROP or ALTER the external function (UDF).

See also:
FLOOR()

back to top of page
<< CAST() | FB 2.5 Language Reference | CHAR_LENGTH(), CHARACTER_LENGTH() >>
<< CAST() | FB 2.1 Language Reference | CHAR_LENGTH(), CHARACTER_LENGTH() >>