Example: EXPAND ON for a WEEK_BEGIN Anchor Point - Analytics Database - Teradata Vantage

This example expands employee using a WEEK_BEGIN anchor point.

Assume the following table definition.

     CREATE SET TABLE employee, NO FALLBACK (
       eid       INTEGER,
       ename     CHARACTER(20) CHARACTER SET LATIN NOT CASESPECIFIC,
       jobperiod PERIOD(DATE))
     PRIMARY INDEX (eid);

Table employee contains the following single row.

Expand employee by WEEK_BEGIN.

     SELECT eid, ename, BEGIN(expd) AS tsp
     FROM employee
     EXPAND ON jobperiod expd BY ANCHOR WEEK_BEGIN;

In this example, each expanded row value starts on a Monday because the week starts on a Monday.