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 |