Explicit DATE-to-UDT conversion using Teradata conversion syntax is not supported.
Data type conversions involving UDTs require appropriate cast definitions for the UDTs. To define a cast for a UDT, use the CREATE CAST statement.
Analytics Database performs implicit DATE-to-UDT conversions for the following operations:
- UPDATE
- INSERT
- Passing arguments to stored procedures, external stored procedures, UDFs, and UDMs
- Specific system operators and functions identified in other sections of this document
If no DATE-to-UDT implicit cast definition exists, Vantage looks for other cast definitions that can substitute.
| Implicit Cast Definition Combination | Analytics Database Action | |
|---|---|---|
| Numeric-to-UDT | Character-to-UDT (Non-CLOB Character Type) | |
| X | Uses Numeric-to-UDT implicit cast definition. If multiple Numeric-to-UDT implicit cast definitions exist, Analytics Database returns SQL error. |
|
| X | Uses Character-to-UDT implicit cast definition. If multiple Character-to-UDT implicit cast definitions exist, Analytics Database returns SQL error. |
|
| X | X | Reports an error. |
Substitutions are valid because Vantage can implicitly cast a DATE type to the substitute data type, and then use the implicit cast definition to cast from the substitute data type to the UDT.