17.05 - Expand Interval Literal Expressions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

The following table explains the meanings of the expand interval syntax variables for the EXPAND ON clause.

Expand Interval Description
interval_literal To perform an interval expansion, specify any valid Interval literal value (see Teradata Vantage™ - Data Types and Literals, B035-1143 for a comprehensive list of valid Interval literals).
ANCHOR anchor_name To perform an anchor point expansion, specify an anchor name, but do not specify PERIOD.
ANCHOR PERIOD anchor_name To perform an anchor period expansion, you must specify PERIOD and an anchor name.