CEIL() function returns a number rounded up to the next whole number.
The following illustrates the syntax of the
CEIL() function requires one argument:
numeric_expression is a number (or an expression which evaluates to a number) that is rounded up.
CEIL() function returns a value whose data type is the same as the input argument.
The following statement illustrates how to use the
CEIL() function to round a number up to the nearest integer:
CEIL( 200.25 );
The result is:
Let’s take the
payment tables in the sample database for the demonstration.
The following example calculates the ceiling of amounts paid by customers for rentals:
CEIL(SUM( amount )) amt
INNER JOIN customer
The following picture illustrates the result:
To round a number down to the nearest whole number, you use the
In this tutorial, you have learned how to use the PostgreSQL
CEIL() function to round a number up to the nearest integer, which is greater than or equal to the number.