Link Search Menu Expand Document

FLOOR

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

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