Arithmetic Operator Syntax - Analytics Database - Teradata Vantage

SQL Date and Time Functions and Expressions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
cpk1628111786971.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
pxz1544241488545
lifecycle
latest
Product Category
Teradata Vantage™
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)