The following examples use tables t1 and t2, which are defined as follows:
CREATE TABLE t1 ( c1 INTEGER c2 PERIOD(DATE)) UNIQUE PRIMARY INDEX (c1); CREATE TABLE t2 ( a INTEGER b DATE c DATE) UNIQUE PRIMARY INDEX (a);
The following two INSERT requests both use a PERIOD value constructor:
INSERT INTO t1 VALUES (1, PERIOD(DATE '2005-02-03', DATE '2006-02-04')); INSERT INTO t1 SELECT a, PERIOD(b, c) FROM t2;