Example: Executing a Query on the Employee Table - Teradata Vantage - Analytics 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')

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