Syntax

 

<floor function> ::=

 

 

 

FLOOR ( <numeric value expression> )

 

 

Notes

 

The FLOOR function returns the greatest whole number (scale 0) that is less than or equal to the argument.



 

The data type of the result is the same type as the argument.



 

If the argument is null, then the result is null.



 

 

Examples

 

Expression

 

Result

 

FLOOR( 5 )

5

FLOOR( 5.25 )

5

FLOOR( -5.25 )

-6

 

 


 

Conformance

 

SQL:2003 standard

-

Feature T621 "Enhanced numeric functions"