# Arithmetic, Trigonometric, Hyperbolic Operators/Functions - Analytics Database - Teradata Vantage

## SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
Product Category

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.