CEIL Function

Description

The CEIL function returns the smallest integer that is not less than its argument. The return value is determined based on the valid number of digits that are specified as the number_operand argument.

Syntax

CEIL( number_operand )

Example

SELECT CEIL(34567.34567), CEIL(-34567.34567);

  ceil(34567.34567)     ceil(-34567.34567)

============================================

  34568.00000           -34567.00000

 

SELECT CEIL(34567.1), CEIL(-34567.1);

  ceil(34567.1)         ceil(-34567.1)

=============================

  34568.0         -34567.0