> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for FLOOR function

# FLOOR

Rounds an input `<value>` down to the nearest multiple based on the specified precision or decimal place. Optionally, you can specify a second parameter to determine which decimal place the value should be rounded down to.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
FLOOR(<value>);
FLOOR(<value>, <digit>);
```

## Parameters

| Parameter | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Supported input types         |
| :-------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :---------------------------- |
| `<value>` | The number to be rounded down to the nearest specified place.                                                                                                                                                                                                                                                                                                                                                                                                                                                        | `NUMERIC`, `DOUBLE PRECISION` |
| `<digit>` | (Optional) You can specify a second parameter to define the position of the digit to round down to, based on its distance from the decimal point. Positive numbers indicate digits after the decimal, while negative numbers refer to digits before the decimal. For example, `1` rounds down to the first digit after the decimal, and `-1` rounds down to the nearest ten. A value of `0` rounds down to the nearest whole number. The default is `0`, which means that rounding down happens at the whole number. | `INTEGER`                     |

## Return Type

| Input Type         | Output Type                                  |
| :----------------- | :------------------------------------------- |
| `NUMERIC`          | `NUMERIC` with same `precision` and `scale`. |
| `DOUBLE PRECISION` | `DOUBLE PRECISION`                           |

## Remarks

When the input is of type `NUMERIC`, `FLOOR` throws an overflow error if the result of `FLOOR` exceeds the defined precision and scale limits of the return data type.

The following code example calculates the nearest whole number smaller than `-99.99` and specifies that the output should contain a total of `4` digits, with only `2` digits reserved for the decimal part.

Returns an `OVERFLOW ERROR` because `FLOOR` returns `-100.00`, which exceeds the `NUMERIC(4,2)` data type's limit of `2` digits before the decimal point, and `-100` requires `3` digits.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT FLOOR(-'99.99'::NUMERIC(4,2));
```

## Examples

The following example returns the nearest whole number smaller than `2.5549900`:

<div className="query-window">
  ```
  SELECT FLOOR(2.5549900);
  ```

  | floor <span>double</span> |
  | :------------------------ |
  | 2                         |

  <p><span>Rows: 1</span><span>Execution time: 7.28ms</span></p>
</div>

The following example calculates the nearest whole number smaller than `213.1549`, and returns a result of type `NUMERIC(20,4)`, which allows for a total of 20 digits, with 4 values allowed after the decimal point:

<div className="query-window">
  ```
  SELECT FLOOR('213.1549'::NUMERIC(20,4));
  ```

  | floor <span>Decimal(20, 4)</span> |
  | :-------------------------------- |
  | 213.0                             |

  <p><span>Rows: 1</span><span>Execution time: 5.25ms</span></p>
</div>

The following code example rounds the number `2.5549900` down to the second decimal place.
It returns `2.55` because the second parameter 2 specifies rounding to the second digit after the decimal, which corresponds to the hundredths place.

<div className="query-window">
  ```
  SELECT FLOOR(2.5549900, 2);
  ```

  | floor <span>double</span> |
  | :------------------------ |
  | 2.55                      |

  <p><span>Rows: 1</span><span>Execution time: 5.47ms</span></p>
</div>

The following example calculates the nearest whole number smaller than `1998` that is a multiple of `1000`.
It returns `1000` because the second parameter -3 specifies rounding to the third digit before the decimal point, which corresponds to the thousands place.

<div className="query-window">
  ```
  SELECT FLOOR(1998, -3);
  ```

  | floor <span>double</span> |
  | :------------------------ |
  | 1000                      |

  <p><span>Rows: 1</span><span>Execution time: 5.25ms</span></p>
</div>