Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Functions : FLOOR
 

FLOOR

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