Examples | DATE-to-Period Conversion | Teradata Vantage - Example: Casting a DATE literal as PERIOD(DATE) - Advanced SQL Engine - Teradata Database

In the following example, a DATE literal is cast as PERIOD(DATE). The result beginning bound is obtained from the source. The result ending element is set to the result beginning bound plus INTERVAL '1' DAY.

SELECT CAST(DATE '2005-02-03' AS PERIOD(DATE));

The following PERIOD(DATE) value is returned:

('2005-02-03', '2005-02-04')