# FLOOR

Rounds a number down to the next lowest integer.

## Syntax

```sql
FLOOR ( expression )

```

## Arguments

* expression: any valid numeric expression.

## Return Type

Integer.

## Examples

```sql
SELECT FLOOR(98.6), FLOOR(-98.6);

```

```output

+-------------+--------------+
| FLOOR(98.6) | FLOOR(-98.6) |
+-------------+--------------+
|          98 |          -99 |
+-------------+--------------+

```

***

Modified at: February 24, 2023

Source: [/db/v9.1/reference/sql-reference/numeric-functions/floor/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/floor/)

(An index of the documentation is available at /llms.txt)