floor returns a 32-bit integer.
floor calculates the largest integer smaller than or equal to x.
SQL> select floor (-0.513513), floor (0.513513), floor (123.4567); callret callret callret INTEGER INTEGER INTEGER _______________________________________________________________________________ -1 0 123 1 Rows. -- 3 msec.