Example: Converting a string_expr to a DATE Data Type - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment: VantageCloud
Edition: Lake
Product: Teradata VantageCloud Lake
Release Number
Published: February 2025
ft:locale: en-US
ft:lastEdition: 2025-11-21
dita:mapPath: jbe1714339405530.ditamap
dita:ditavalPath: pny1626732985837.ditaval
dita:id: jbe1714339405530

The following query:

SELECT TO_DATE ('January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH: MI A.M.');

returns the result 15-JAN-89.