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) |