17.10 - Arithmetic, Trigonometric, Hyperbolic Operators/Functions - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)

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)