17.10 - Arithmetic Operator Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1211-171K
Language
English (United States)
period_expression {+|-} interval_expression
The order of period_expression and interval_expression is not important.

Syntax Elements

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)