meta data for this page
  •  

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).