8.2.11. FLOOR()

Available in

DSQL, PSQL

Possible name conflict

YES → Read details

Syntax

  1. FLOOR (number)
Table 109. FLOOR Function Parameter
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 largest whole number smaller than or equal to the argument.

See also

CEIL(), CEILING()