Difference between revisions of "FLOOR()"

Revision as of 15:03, 23 March 2009

Class

Numeric Data

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