Example: Creating a Table with a Derived Period Column - Advanced SQL Engine - Teradata Database

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