Neoview SQL Reference Manual (R2.4 SP2)

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 a Neoview SQL extension.
FLOOR (numeric-expression)
numeric-expression
is an SQL numeric value expression that specifies the value for the argument of the FLOOR
function. See “Numeric Value Expressions” (page 253).
Examples of FLOOR
This function returns the integer value 2.00000000000000000E+000, represented as a FLOAT data
type:
FLOOR (2.25)
FLOOR Function 393