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