Link Search Menu Expand Document

FLOOR

Returns the largest round number that is less than or equal to the input value. The value is rounded to a decimal range defined by <decimal>.

Syntax

FLOOR(<value>[, <decimal>])

Parameters

Parameter Description Supported input types
<value> Valid values include column names, functions that return a column with numeric values, and constant numeric values. DOUBLE PRECISION
<decimal> Optional. A constant that defines the decimal range of the returned value. By default, FLOOR returns whole numbers. INTEGER

Return Type

DOUBLE PRECISION

Example

The following example returns the largest round number that is less than or equal to the value 2.19:

SELECT
    FLOOR(2.19, 1);

Returns: 2.1