17.05 - Rules and Restrictions for Interval Expansion - 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 rules and restrictions for the use of Interval Expansions are as follows:
  • An expansion commences from the beginning value of the expansion period and ends at its ending value with an incremental value set to the specified interval literal for each row to be expanded.

    In this process, the last expanded row may not always cover the expansion interval duration. If this occurs, the result is a partial period, which is a period having a duration that is less than the expansion interval.

  • If one or more rows in the expanded result has an expansion period duration that is less than the specified interval, and the interval being expanded also has a higher granularity than the element type of the period being expanded, the database returns a warning to the requestor. SeeExample: Creating a Time Series Using Expansion By an Interval Constant Value.
  • Unlike anchor period expansions, Vantagedoes not use a system-defined business calendar set for an interval literal in an EXPAND ON clause.