The PostgreSQL FLOOR() function returns a number rounded down to the next whole number.
Syntax
The syntax of the FLOOR() function is as follows:
1 | 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:
1 2 | SELECT FLOOR( 150.75 ); |
The result is:
1 | 150 |
See the following payment table in the sample database:
The following statement returns the floor of amount paid by customer:
1 2 3 4 5 6 7 8 9 | 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.