END returns the ending bound (jdend) of a derived period called jobduration created using the following SQL statement:
CREATE TABLE employee(id INTEGER, name VARCHAR(50), jdbegin DATE NOT NULL FORMAT 'YYYY-MM-DD', jdend DATE NOT NULL FORMAT 'YYYY-MM-DD', PERIOD FOR jobduration(jdbegin,jdend) )PRIMARY INDEX(id);
The following SQL statements:
INSERT INTO employee(1025,'John',DATE'2011-01-02',DATE'2012-05-02'); SELECT END (jobduration) FROM employee;
return is:
jdend __________ 2011-05-02