Assume the following query is executed on the employee table where period1 is a PERIOD(DATE) column:
SELECT * FROM employee WHERE NEXT(END(period1)) = DATE '2004-03-06';
ename dept period1 ----- ----------- ---------------------------- Jones Sales ('2004-01-02', '2004-03-05') Simon Sales ?
The result is:
ename dept period1 ----- ----------- ---------------------------- Jones Sales ('2004-01-02', '2004-03-05')