Syntax

 

<ceiling function> ::=

 

 

 

{ CEIL | CEILING } ( <numeric value expression> )

 

 

Notes

 

The CEILING function returns the smallest whole number (scale 0) that is greater than or equal to the argument.



 

The data type of the result is the same type as the argument.



 

If the argument is null, then the result is null.



 

 

Examples

 

Expression

 

Result

 

CEILING( 5 )

5

CEILING( 5.25 )

6

CEILING( -5.25 )

-5

 

 


 

Conformance

 

SQL:2003 standard

-

Feature T621 "Enhanced numeric functions"