SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-22
CEILING Function
VALUES (001, 'User JBrook, executed at ' ||
CAST (CURRENT_TIMESTAMP AS CHAR(26)));
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-48.
Examples of CEILING
•
This function returns the integer value 3.00000000000000064E+000, represented
as a FLOAT data type:
CEILING (2.25)
CEILING (numeric-expression)