Examples | INTERVAL Function | Teradata Vantage - Example: Using the INTERVAL Function - Analytics Database - Teradata Vantage

The following example uses the INTERVAL function:

SELECT INTERVAL(PERIOD(DATE '2016-02-29',  DATE '2016-03-01')) MONTH ;

Result:

INTERVAL(PERIOD(2016-02-29, 2016-03-01)) MONTH
----------------------------------------------
                                             1

The result is an INTERVAL value.