Search

1. Preface
2. The Transformation Language
3. Constants
4. Operators
5. Variables
6. Dates
7. Functions
8. Creating Custom Functions
9. Custom Function API Reference # Arithmetic Operators

Use arithmetic operators to perform mathematical calculations on numeric data.
The following table lists the arithmetic operators in order of precedence in the transformation language:
Operator
Meaning
+, -
Unary plus and minus. Unary plus indicates a positive value. Unary minus indicates a negative value.
*, /, %
Multiplication, division, modulus. A modulus is the remainder after dividing two integers. For example, 13 % 2 = 1 because 13 divided by 2 equals 6 with a remainder of 1.
+, -
The addition operator (+) does not concatenate strings. To concatenate strings, use the string operator ||. To perform arithmetic on date values, use the date functions.
If you perform arithmetic on a null value, the function returns NULL.
When you use arithmetic operators in an expression, all of the operands in the expression must be numeric. For example, the expression
1 + '1'
is not valid because it adds an integer to a string. The expression
1.23 + 4 / 2
is valid because all of the operands are numeric.
The transformation language provides built-in date functions that let you perform arithmetic on date/time values. Updated February 10, 2020

Resources