SET_SCALE
Description
Rounds a number to the specified number of decimal places using half-even rounding.
Syntax
SET_SCALE(num, num_digits) -> Decimal
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| num | Number | Yes | A numeric literal, field, or expression to format. |
| num_digits | Integer | Yes | The number of digits to keep after the decimal point. |
Examples
SET_SCALE(12.345, 2)
-- Returns 12.34.SET_SCALE(-2.25, 1)
-- Returns -2.2.