Usage Notes - Analytics Database - Teradata Vantage
ANSI Temporal Table Support
- 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
- jqu1628112571823.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- esa1472244798285
- lifecycle
- latest
- Product Category
- Teradata Vantageā¢
- If no temporal qualifiers are used in the FROM clause, the default for system-time tables is to qualify all rows that are currently (at the time of the query) open.
- BETWEEN ... AND, FROM TO, and CONTAINED IN all qualify queries of temporal tables according to a period of time. Any table rows that were active in the database, open in system time, at any time during the specified period (or immediately after it in the case of BETWEEN ... AND) are qualified for the query. The differences in the three temporal qualifiers are subtle, but allow you to define your query to qualify a precise set of rows.