PostgreSQL FLOOR
From w3cyberlearnings
Contents |
Postgresql FLOOR
This function returns the largest value that is not greater than X.
Syntax FLOOR
X is an integer.
FLOOR(X);
Example 1
postgres=# SELECT FLOOR(3.9); floor ------- 3 (1 row)
Example 2
postgres=# SELECT FLOOR(-3.9); floor ------- -4 (1 row)