FLOOR

Restriction: This topic applies to Windows environments only.

ANSI	DB2	SQL/DS	XDB
			X

Finds the largest integer less than or equal to the value of expr. The format appears below:

FLOOR(expr)

For example:

FLOOR(12.25) = 12
FLOOR(12) = 12