17.00 - 17.05 - Example: Executing a Query on the Employee Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Programming Reference
Publication ID
B035-1211-170K
Language
English (United States)

Assume the following query is executed on the employee table with PERIOD(DATE) column period1:

SELECT INTERVAL (period1) MONTH FROM employee;
ename   dept          period1
-----   -----------   ----------------------------
Jones   Sales         ('2004-01-02', '2004-03-05')

The result is:

 INTERVAL(period) MONTH
-----------------------
                      2