FLOOR: Returning the Largest Integer Less Than or Equal to a Value (SQL)

FLOOR returns the largest integer value not greater than a value.

Return the Largest Integer Less Than or Equal to a Value

FLOOR(n)

where:

n

Numeric or Alphanumeric

Is the value greater than or equal to the returned integer. For exact-value numeric arguments, the return value has an exact-value numeric type. For alphanumeric or floating-point arguments, the return value has a floating-point type.

Returning an Integer Less Than or Equal to a Value

FLOOR returns an integer less than or equal to the argument.

FLOOR(N)

For N=1.23, the result is 1.

For N=-1.23, the result is -2.