Example: EXPAND ON for a QUARTER_BEGIN Anchor Period - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

This example expands employee using a QUARTER_BEGIN anchor period.

     SELECT eid, ename, BEGIN(expd) AS tsp
     FROM employee
     EXPAND ON jobdperiod expd BY ANCHOR PERIOD QUARTER_BEGIN;
eid ename tsp
1001 Xavier 2008-04-01