FLOOR Function

Description

The FLOOR function returns the largest integer that is not greater than its argument. The data type of the return value is the same as that of the argument.

Syntax

FLOOR( number_operand )

Example

--it returns the largest integer less than or equal to the arguments

SELECT FLOOR(34567.34567), FLOOR(-34567.34567);

  floor(34567.34567)    floor(-34567.34567)

============================================

  34567.00000           -34568.00000

 

SELECT FLOOR(34567), FLOOR(-34567);

  floor(34567)   floor(-34567)

=============================

         34567         -34567