WebSphere Message Brokers
File: ak05350_
Writer: Bill Oppenheimer

Reference topic

This build: July 31, 2007 21:31:54

CEIL and CEILING functions

The CEIL and CEILING numeric functions return the smallest integer equivalent of a decimal number.

Syntax

CEIL and CEILING return the smallest integer value greater than or equal to source_number. The parameter can be any numeric data type. The result is of the same type as the parameter unless it is NULL, in which case the result is NULL.

For example:
CEIL(1)
returns 1
CEIL(1.2)
returns 2.0
CEIL(-1.2)
returns -1.0

If possible, the scale is changed to zero. If the result cannot be represented at that scale, it is made sufficiently large to represent the number.

Related concepts
ESQL overview
Related tasks
Developing ESQL
Related reference
Syntax diagrams: available types
ESQL numeric functions
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:31:54

ak05350_ This topic's URL is: