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.


See also

ceiling