Returns the largest integer less than or equal to expression.

Syntax

FLOOR ( expression )

Notes

expression must evaluate to a numeric data type.

Example

This example illustrates the FLOOR function:

SELECT FLOOR (32.5) 'Floor' from sysprogress.syscalctable ;

Compatibility

ODBC compatible