Jump to: navigation, search

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)

Related Links



Navigation
Web
SQL
MISC
References