FLOOR
Returns a number rounded down to the nearest integer.
PostgreSQL 17.5
FLOOR(num)Parameters
- numnumeric | double precision
- Number to round
Return value
A whole value: numeric for numeric, double precision for double precision and for an integer argument
Examples
Positive fraction
PostgreSQL 17.5
SELECT FLOOR(0.2);Negative fraction
PostgreSQL 17.5
SELECT FLOOR(-0.2);Whole number
PostgreSQL 17.5
SELECT FLOOR(3);Details
Negative numbers are rounded away from zero: FLOOR(-1.2) returns -2.