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. |