Example: Converting Period Data to a DATE Value - Teradata Vantage

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