OVERLAPS 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
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
cpk1628111786971.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
pxz1544241488545
lifecycle
latest
Product Category
Teradata Vantageā„¢
time_period_expression OVERLAPS time_period_expression

Syntax Elements

time_period_expression
{ ( { datetime_expression, { datetime_expression | interval_expression } |
      row_subquery
    } ) |
  period_expression |
  derived_expression
}
datetime_expression
A start and end DateTime.
interval_expression
An end DateTime.
row_subquery

A subquery that selects the same number of expressions as are specified in the expression or list of expressions.

The subquery cannot specify a SELECT AND CONSUME statement.

period_expression
The Period expression to be converted.
derived_period
Any expression that evaluates to a Period data type.