FLOOR

FLOOR returns largest integer equal to or less than a specified number.

Return Value

NUMBER 

Syntax

FLOOR(n)

Arguments

n can be any numeric expression.

Examples

FLOOR(15.7) returns the value 15.00.

FLOOR(-15.7) returns the value -16.00.

Copyright © 2003, 2007, Oracle. All rights reserved.