17.10 - Example: FROM TO Query on ANSI Valid-Time Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)

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’;

 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