Example: Executing a Query on the Employee Table - Advanced SQL Engine - Teradata Database

Assume the following query is executed on the employee table with PERIOD(DATE) column period1:

SELECT INTERVAL (period1) MONTH FROM employee;
ename   dept          period1
-----   -----------   ----------------------------
Jones   Sales         ('2004-01-02', '2004-03-05')

The result is:

 INTERVAL(period) MONTH
-----------------------
                      2