Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateInternal functions → CEIL(), CEILING()
Firebird Home Firebird Home Prev: CAST()Firebird Documentation IndexUp: Internal functionsNext: CHAR_LENGTH(), CHARACTER_LENGTH()

CEIL(), CEILING()

Available in: DSQL, PSQL

Added in: 2.1

Description: Returns the smallest whole number 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()

Prev: CAST()Firebird Documentation IndexUp: Internal functionsNext: CHAR_LENGTH(), CHARACTER_LENGTH()
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateInternal functions → CEIL(), CEILING()