Name
floor — Round a number to negative infinity.
Synopsis
floor
(
|
in
x
double precision
); |
Description
floor calculates the largest integer smaller than or
equal to x.
Parameters
x
double precision
Return Values
floor returns a 32-bit integer.
Examples
Example 24.126. Simple Examples
SQL> select floor (-0.513513), floor (0.513513), floor (123.4567);
callret callret callret
INTEGER INTEGER INTEGER
_______________________________________________________________________________
-1 0 123
1 Rows. -- 3 msec.