15.00 - Valid fromsql Transform Functionality - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Valid fromsql Transform Functionality

The following table documents the valid targets for fromsql functionality.

 

Source Input

Source Data Type of Routine Definition

Target Data Type of Routine Definition

Target Output

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

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
CHARACTER VARYING

CLOB

CLOB
CHARACTER
VARCHAR

UDT (continued)

UDT (continued)

DATE

DATE
BYTEINT
SMALLINT
INTEGER
BIGINT
DECIMAL
NUMERIC
REAL
FLOAT
DOUBLE PRECISION
CHARACTER
VARCHAR

TIME

TIME
TIME WITH TIME ZONE

TIME WITH TIME ZONE

TIMESTAMP

TIMESTAMP
TIMESTAMP WITH TIME ZONE

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