Example: Converting Period Data to a DATE Value

Teradata Vantage™ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Assume pd is a PERIOD(DATE) column in table t with a value of 
PERIOD '(2005-02-02, 2005-02-03)'.

In the following example, a PERIOD(DATE) column is cast as DATE. The result is the beginning bound of the column.

SELECT CAST(pd AS DATE) FROM t;

The following is returned:

2005-02-02