This query specifies the same period as the CONTAINED IN example, but in the case of a FROM TO qualifier, any rows with valid-time periods that overlap the specified time period will be returned.
SELECT * FROM employee_vt FOR VALIDTIME FROM DATE’2004-01-01’ TO DATE’2005-12-31’;
Output:
eid ename terms job_start job_end ---- ----- ----- ---------- ----------- 1005 Alice TW11 2004/12/01 2005/12/01 1004 Fred PW12 2001/05/01 9999/12/31 1005 Alice PW11 2005/12/01 9999/12/31 1003 SRK TM02 2004/02/10 2005/02/09 1001 Sania TW08 2002/01/01 2006/12/31