PostgreSQL CEILING
From w3cyberlearnings
Contents |
Postgresql CEILING
This function returns the smallest value integer not less than X, and it is equal to the CEIL() function.
Syntax CEILING
X is a value to round.
CEILING(X);
Example 1
postgres=# SELECT CEILING(2.5); ceiling --------- 3 (1 row)
Example 2
postgres=# SELECT CEILING(2.2); ceiling --------- 3 (1 row)