8.2.6. CEIL(), CEILING()

Available in

DSQL, PSQL

Possible name conflict

YES → Read details (Affects CEILING only)

Syntax

  1. CEIL[ING] (number)
Table 104. CEIL[ING] Function Parameters
ParameterDescription

number

An expression of a numeric type

Result type

BIGINT for exact numeric number, or DOUBLE PRECISION for floating point number

Description

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

See also

FLOOR()