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
Example24.118.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.