The following sections describe the SQL arithmetic, trigonometric, and hyperbolic operators and functions.
Teradata SQL supports the following arithmetic operators.
Operator | Function |
---|---|
** | Exponentiate This is a Teradata extension to the ANSI SQL:2011 standard. |
* | Multiply |
/ | Divide |
MOD | Modulo (remainder). MOD calculates the remainder in a division operation. For example, 60 MOD 7 = 4: 60 divided by 7 equals 8, with a remainder of 4. The result takes the sign of the dividend, thus: -17 MOD 4 = -1 -17 MOD -4 = -1 17 MOD -4 = 1 17 MOD 4 = 1 This is a Teradata extension to the ANSI SQL:2011 standard. |
+ | Add |
- | Subtract |
+ | Unary plus (positive value) |
- | Unary minus (negative value) |