Data Integration
- Data Integration
- All Products
fn:round(arg)
Argument
| Required/
Optional
| Description
|
---|---|---|
arg
| Required
| Must be a numeric data type. You can enter any valid transformation expression. Use operators to perform arithmetic before you round the values.
To pass a NULL value, you must specify an empty sequence in the following format:
()
The function rounds to the nearest integer, truncating the decimal portion of the number. For example, round(12.99) returns 13 and round(15.20) returns 15.
|
fn:round(PRICE)
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
fn:round-half-to-even(arg, precision)
fn:round-half-to-even(PRICE, 3)
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
fn:round-half-to-even(PRICE, -2)
|
|
---|---|
|
|
|
|
|
|
|
|
fn:round-half-to-even(PRICE, 0)
|
|
---|---|
|
|
|
|
|
|
|
|
|
|