Arithmetic Operators | SQL Date/Time Functions & Expressions | Teradata Vantage - 17.00 - 17.05 - Arithmetic Operators - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Programming Reference
Publication ID
B035-1211-170K
Language
English (United States)

Adds or subtracts an Interval value to or from a Period value, or adds a Period value to an Interval value.

Syntax

period_expression {+|-} interval_expression
The order of period_expression and interval_expression is not important.
period_expression

The Period expression to be converted.

Any expression that evaluates to a Period data type.

interval_expression

An expression that evaluates to an INTERVAL data type.

Assuming that p is a Period expression of element type DATE or TIMESTAMP and v is an Interval expression:
  • p + v and v + p are both equivalent to:
    PERIOD(BEGIN(p) + v, CASE WHEN END(p) IS UNTIL_CHANGED THEN END(p) ELSE (END(p) + v) END)
  • p - v is equivalent to:
    PERIOD(BEGIN (p) - v, CASE WHEN END(p) IS UNTIL_CHANGED THEN END(p) ELSE (END(p) - v) END)
Assuming that p is a Period expression of element type TIME and v is an interval expression:
  • p + v and v + p are both equivalent to:
    PERIOD(BEGIN(p) + v, END(p) + v)
  • p - v is equivalent to:
    PERIOD(BEGIN (p) - v, END(p) - v)