FLOOR returns the largest integer equal to or less than a specified number.
FLOOR
Return Value
NUMBER
Syntax
FLOOR(n)
Arguments
n can be any numeric expression.
n
Examples
FLOOR(15.7) returns the value 15.
FLOOR(15.7)
15
FLOOR(-15.7) returns the value -16.
FLOOR(-15.7)
-16
subject
from Anonymous
Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.
Scripting on this page enhances content navigation, but does not change the content in any way.
Quick Lookup
Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages
Main Categories
This Document