Jump to: navigation, search

PostgreSQL CEIL

From w3cyberlearnings

Contents

Postgresql CEIL

This function returns the smallest value integer not less than X. This function is a synonym of CELING().

Syntax CEIL

X is a value to round.

CEIL(X);

Example 1

postgres=# SELECT CEIL(2.5);
 CEIL 
---------
       3
(1 row)


Example 2


postgres=# SELECT CEIL(2.2);
 CEIL 
---------
       3
(1 row)

Related Links



Navigation
Web
SQL
MISC
References