SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-24
CEILING Function
CEILING Function
The CEILING function returns the smallest integer, represented as a FLOAT data type,
greater than or equal to a numeric value expression.
CEILING is an SQL/MX extension.
numeric-expression
is an SQL numeric value expression that specifies the value for the argument of
the CEILING function. See Numeric Value Expressions on page 6-50.
Examples of CEILING
•
This function returns the integer value 3.00000000000000064E+000, represented
as a FLOAT data type:
CEILING (2.25)
CEILING (numeric-expression)