Data type conversions involving UDTs require appropriate cast definitions for the UDTs. To define a cast for a UDT, use the CREATE CAST statement.
Performing an implicit data type conversion requires a cast definition that specifies the following:
- AS ASSIGNMENT clause
- Target data type that is in the same INTERVAL family as the target of the implicit cast:
| INTERVAL Data Type | INTERVAL Family |
|---|---|
|
Year-Month |
|
Day-Time |
The target data type of the cast definition does not have to be an exact match to the target of the implicit type conversion.
Analytics Database performs implicit UDT-to-INTERVAL 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