Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

floor

floor

Rounds a number to the largest integer that is less than or equal to the passed number.

Syntax

floor(
number
)
The following table describes arguments for this function:
Argument
Description
number
Numeric value. Use a numeric expression.

Return Value

Integer.
NULL if a value passed to the function is NULL.

Example

The following expression returns the largest integer less than or equal to the value in BANK_BALANCE:
floor( BANK_BALANCE )
The following table contains example arguments and return values:
BANK_BALANCE
RETURN VALUE
39.79
39
NULL
NULL
-100.99
-101
5
5

0 COMMENTS

We’d like to hear from you!