w3resource

PostgreSQL CEIL() function

CEIL() function

The PostgreSQL ceil() function is used to return the value, after rounded up any positive or negative decimal value as greater than the argument.

Syntax:

ceil()

PostgreSQL Version: 9.3

Pictorial presentation of PostgreSQL CEIL() function

pictorial presentation of PostgreSQL CEIL() function

Example: PostgreSQL CEIL() function

Code:

SELECT CEIL(53.7) AS "Ceil";

Sample Output:

 Ceil
------
   54
(1 row)

Example: PostgreSQL CEIL() function with negative value

Code:

SELECT CEIL(-53.7) AS "Ceil";

Sample Output:

 Ceil
------
  -53
(1 row)

Previous: CBRT function
Next: CEILING function



Share this Tutorial / Exercise on : Facebook and Twitter