Possible Predefined Type Source and Target User-Defined Cast Combinations - Analytics Database

Possible Predefined Type Source and Target User-Defined Cast Combinations - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment

VantageCloud

VantageCore

Edition

Enterprise

IntelliFlex

VMware

Product

Analytics Database

Teradata Vantage

Release Number

17.20

Published

June 2022

Language

English (United States)

Last Update

2024-10-04

dita:mapPath

vuk1628111288877.ditamap

dita:ditavalPath

qkf1628213546010.ditaval

dita:id

jbg1472252759029

lifecycle

latest

Product Category

Teradata Vantage™

For user-defined casts, the system supports a degree of implicit predefined data type-to-predefined type conversions. The following table lists the inputs for a predefined data type-to-UDT cast and targets for a UDT-to-predefined data type cast.

Source Input	Source Data Type of CAST Definition	Target Data Type of CAST Definition	Target Output
BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION DATE CHARACTER VARCHAR	BYTEINT	UDT	UDT
	SMALLINT
	INTEGER
	BIGINT
	DECIMAL NUMERIC
	REAL FLOAT DOUBLE PRECISION
BYTE VARBYTE BLOB	BYTE
	VARBYTE
	BLOB
CHARACTER VARCHAR CLOB BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION DATE	CHARACTER	UDT	UDT
	VARCHAR
	CLOB
DATE BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION DATE	DATE
TIME TIME WITH TIME ZONE CHARACTER VARCHAR	TIME
TIME TIME WITH TIME ZONE CHARACTER VARCHAR	TIME WITH TIME ZONE
TIMESTAMP TIMESTAMP WITH TIME ZONE CHARACTER VARCHAR	TIMESTAMP
TIMESTAMP TIMESTAMP WITH TIME ZONE CHARACTER VARCHAR	TIMESTAMP WITH TIME ZONE
INTERVAL YEAR INTERVAL YEAR TO MONTH INTERVAL MONTH	INTERVAL YEAR	UDT	UDT
	INTERVAL YEAR TO MONTH
	INTERVAL 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	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
UDT1	UDT1	UDT2	UDT2
UDT	UDT	BYTEINT	BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION CHARACTER VARCHAR DATE
		SMALLINT
		INTEGER
		BIGINT
		DECIMAL NUMERIC
		REAL FLOAT DOUBLE PRECISION
UDT	UDT	BYTE	BYTE VARBYTE BLOB
		VARBYTE
		BLOB
		CHARACTER	CHARACTER VARCHAR CLOB BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION DATE TIME TIME WITH TIME ZONE TIMESTAMP TIMESTAMP WITH TIME ZONE
		VARCHAR
		CLOB
		DATE	DATE BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION CHARACTER VARCHAR
UDT	UDT	TIME	TIME TIME WITH TIME ZONE
		TIME WITH TIME ZONE	TIME TIME WITH TIME ZONE
		TIMESTAMP	TIMESTAMP TIMESTAMP WITH TIME ZONE
		TIMESTAMP WITH TIME ZONE	TIMESTAMP TIMESTAMP WITH TIME ZONE
		INTERVAL YEAR	INTERVAL YEAR INTERVAL YEAR TO MONTH INTERVAL MONTH
		INTERVAL YEAR TO MONTH
		INTERVAL MONTH
		INTERVAL DAY	INTERVAL DAY INTERVAL DAY TO HOUR INTERVAL DAY TO SECOND INTERVAL HOUR INTERVAL HOUR TO MINUTE INTERVAL HOUR TO SECOND INTERVAL MINUTE INTERVAL MINUTE TO SECOND INTERVAL SECOND
		INTERVAL DAY TO HOUR
		INTERVAL DAY TO SECOND
		INTERVAL HOUR
		INTERVAL HOUR TO MINUTE
		INTERVAL HOUR TO SECOND
		INTERVAL MINUTE
		INTERVAL MINUTE TO SECOND
		INTERVAL SECOND
ARRAY/VARRAY	ARRAY/VARRAY	XML	XML
BLOB	BLOB
CLOB	CLOB
DATE	DATE
DECIMAL NUMERIC	DECIMAL NUMERIC
NUMBER	NUMBER
FLOAT REAL DOUBLE PRECISION	FLOAT REAL DOUBLE PRECISION
BYTEINT SMALLINT INTEGER BIGINT	BYTEINT SMALLINT INTEGER BIGINT
NUMBER	NUMBER
NUMERIC	NUMERIC
INTERVAL DAY	INTERVAL DAY
INTERVAL DAY TO HOUR	INTERVAL DAY TO HOUR
INTERVAL DAY TO MINUTE	INTERVAL DAY TO MINUTE
INTERVAL DAY TO SECOND	INTERVAL DAY TO SECOND
INTERVAL HOUR	INTERVAL HOUR
INTERVAL HOUR TO MINUTE	INTERVAL HOUR TO MINUTE
INTERVAL HOUR TO SECOND	INTERVAL HOUR TO SECOND
INTERVAL MINUTE	INTERVAL MINUTE
INTERVAL MINUTE TO SECOND	INTERVAL MINUTE TO SECOND
INTERVAL MONTH	INTERVAL MONTH
INTERVAL SECOND	INTERVAL SECOND
INTERVAL YEAR	INTERVAL YEAR
INTERVAL YEAR TO MONTH	INTERVAL YEAR TO MONTH
PERIOD	PERIOD
TIME	TIME
TIMESTAMP	TIMESTAMP
TIMESTAMP WITH TIME ZONE	TIMESTAMP WITH TIME ZONE
BYTE VARBYTE LONG VARBYTE	BYTE VARBYTE LONG VARBYTE
CHARACTER VARCHAR	CHARACTER VARCHAR
XML	XML	BLOB	BLOB
		CLOB	CLOB
		DATE	DATE
		DECIMAL NUMERIC	DECIMAL NUMERIC
		NUMBER	NUMBER
		FLOAT REAL DOUBLE PRECISION	FLOAT REAL DOUBLE PRECISION
		BYTEINT SMALLINT INTEGER BIGINT	BYTEINT SMALLINT INTEGER BIGINT
		INTERVAL DAY	INTERVAL DAY
		INTERVAL DAY TO HOUR	INTERVAL DAY TO HOUR
		INTERVAL DAY TO MINUTE	INTERVAL DAY TO MINUTE
		INTERVAL DAY TO SECOND	INTERVAL DAY TO SECOND
		INTERVAL HOUR	INTERVAL HOUR
		INTERVAL HOUR TO MINUTE	INTERVAL HOUR TO MINUTE
		INTERVAL HOUR TO SECOND	INTERVAL HOUR TO SECOND
		INTERVAL MINUTE	INTERVAL MINUTE
		INTERVAL MINUTE TO SECOND	INTERVAL MINUTE TO SECOND
		INTERVAL MONTH	INTERVAL MONTH
		INTERVAL SECOND	INTERVAL SECOND
		INTERVAL YEAR	INTERVAL YEAR
		INTERVAL YEAR TO MONTH	INTERVAL YEAR TO MONTH
		PERIOD	PERIOD
		TIME	TIME
		TIMESTAMP	TIMESTAMP
		TIMESTAMP WITH TIME ZONE	TIMESTAMP WITH TIME ZONE
		BYTE VARBYTE LONG VARBYTE	BYTE VARBYTE LONG VARBYTE
		CHARACTER VARCHAR	CHARACTER VARCHAR