Overview

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

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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)