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