Performing an implicit data type conversion requires a cast definition (see Usage Notes) that specifies the following:
- the AS ASSIGNMENT clause
- a source data type that is in the same INTERVAL family as the source of the implicit cast:
| This INTERVAL data type … | Belongs to this INTERVAL family … |
|---|---|
|
Year-Month |
|
Day-Time |
The source data type of the cast definition does not have to be an exact match to the source of the implicit type conversion.
Analytics Database performs implicit INTERVAL-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, unless the DisableUDTImplCastForSysFuncOp field of the DBS Control Record is set to TRUE