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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-60
FLOOR Function
FLOOR Function
The FLOOR function returns the largest integer, represented as a FLOAT data type,
less than or equal to a numeric value expression.
FLOOR is an SQL/MX extension.
numeric-expression
is an SQL numeric value expression that specifies the value for the argument of
the FLOOR function. See Numeric Value Expressions on page 6-48.
Examples of FLOOR
•
This function returns the integer value 2.00000000000000040E+000, represented
as a FLOAT data type:
FLOOR (2.25)
FLOOR (numeric-expression)