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