4.9.2.32 FLOOR function (ODBC compatible)

Syntax

FLOOR ( expression )

Description

The scalar function FLOOR returns the largest integer less than or equal to expression.

Example

SELECT FLOOR (32.5) 'Floor'
     FROM SYSTPE.SYSCALCTABLE;

Notes

• expression must evaluate to a numeric data type.