Example: Converting a Numeric Integer Expression to a Date Format - Advanced SQL Engine - Teradata Database

This example casts the numeric integer expression to a date format.

SELECT CAST (1071201 AS DATE);

The result looks like this when the DateForm mode of the session is set to ANSIDate:

   1071201
----------
2007-12-01