Difference between revisions of "FLOOR()"

Revision as of 15:18, 27 October 2009

Purpose

Function to return the largest integer that is less than or equal to a given number

Syntax

FLOOR(<expN>)

See Also

CEILING(), ISDIGIT(), SIGN()

Description

The FLOOR() function is used to return the largest integer that is less than or equal to <expN>.

Example

? floor(354.89)
       354
? floor(354.19)
       354
? floor(-354.89)
      -355

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer