Assume the following query runs on the employee table with PERIOD(DATE) column period1:
SELECT INTERVAL (period1) MONTH FROM employee;
The employee table contains:
ename dept period1
----- ----------- ----------------------------
Jones Sales ('2004-01-02', '2004-03-05')
The result is:
INTERVAL(period) MONTH ----------------------- 2