OVERLAPS Time Periods - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

If the start and end DateTime values in a time period are not ordered chronologically, these values are manipulated before making the comparison, using the rule that end_DateTime >= start_DateTime.

If a time period contains a null start_DateTime and a non-null end_DateTime, the values are switched to indicate a non-null start_DateTime and a null end_DateTime.

Implicit casting to a Period data type is not supported.