August 7, 2023

**Summary**: The PostgreSQL `FLOOR()`

function returns a number rounded down to the next whole number.

**Table of Contents**

## Syntax

The syntax of the `FLOOR()`

function is as follows:

```
FLOOR(numeric_expression)
```

## Arguments

The `FLOOR()`

function requires one argument:

**1) numeric_expression**

The numeric_expression is a number (or an expression which evaluates to a number) that is rounded down.

## Return Value

The `FLOOR()`

function returns a value whose data type is the same as the input argument.

## Examples

The following example shows how to use the `FLOOR()`

function to round a number down to the nearest integer:

```
SELECT
FLOOR( 150.75 );
```

The result is:

```
150
```

See the following `payment`

table in the sample database:

The following statement returns the floor of amount paid by customer:

```
SELECT
customer_id,
FLOOR(SUM( amount )) amount_paid
FROM
payment
GROUP BY
customer_id
ORDER BY
amount_paid DESC;
```

The following picture illustrates the result:

## Remarks

To round a number up to the nearest whole number, you use the `CEIL()`

function.

In this tutorial, you have learned how to use the PostgreSQL `FLOOR()`

function to round a number down to the nearest integer, which is less than or equal to the number.

## See more

PostgreSQL Tutorial: Math Functions

PostgreSQL Documentation: Mathematical Functions and Operators