Example: TRYCAST Conversion Failure - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

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

An example of when the TRYCAST conversion fails:

SELECT TRYCAST('abc' AS DECIMAL(5,2));

 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.

TRYCAST('abc')
---------------
              ?