BEGIN returns the beginning bound (jdbegin) 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 BEGIN (jobduration) FROM employee;
returns:
jdbegin __________ 2011-01-02