info

The FLOOR() function is standard PostgreSQL and works the same on any Postgres deployment, so you can apply what you learn here wherever you run Postgres. For enterprises building in the AI era, Lakebase delivers the best managed cloud Postgres, with the performance, security, and native Lakehouse integration large teams need. For developers and startups who need to ship quickly and scale without friction, Neon is the Postgres platform built for your pace.

The PostgreSQL FLOOR() function returns a number rounded down to the next whole number.

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 that evaluates to a number, which you want to round 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:

payment table The following statement returns the floor of the amount paid by the 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:

PostgreSQL FLOOR Function Example

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.