Jump to: navigation, search

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)

Related Links



Navigation
Web
SQL
MISC
References