SQL Reference Guide

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 ADMIN.SYSCALCTABLE;

Notes

• Expression must evaluate to a numeric data type.