This example creates a table, employee , with a derived period column, jobduration , where jobstart is the period begin column name and jobend is the period end column name.
CREATE TABLE employee ( eid INTEGER NOT NULL, name VARCHAR(100) NOT NULL, deptno INTEGER NOT NULL, jobstart DATE NOT NULL, jobend DATE NOT NULL, PERIOD FOR jobduration(jobstart, jobend) ) PRIMARY INDEX(eid);