17.10 - Implicit INTERVAL-to-UDT Conversion - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)
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 …
  • INTERVAL YEAR
  • INTERVAL YEAR TO MONTH
  • INTERVAL MONTH
Year-Month
  • INTERVAL DAY
  • INTERVAL DAY TO HOUR
  • INTERVAL DAY TO MINUTE
  • INTERVAL DAY TO SECOND
  • INTERVAL HOUR
  • INTERVAL HOUR TO MINUTE
  • INTERVAL HOUR TO SECOND
  • INTERVAL MINUTE
  • INTERVAL MINUTE TO SECOND
  • INTERVAL SECOND
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.

SQL Engine 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