15.00 - Valid tosql Transform Functionality - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Valid tosql Transform Functionality

The following table documents the valid inputs for tosql functionality.

 

Source Input

Source Data Type of Routine Definition

Target Data Type of Routine 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

VARCHAR
CHARACTER VARYING

CHARACTER
VARCHAR
CLOB

CLOB

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

DATE

UDT

UDT

TIME
TIME WITH TIME ZONE
CHARACTER
VARCHAR

TIME

TIME WITH TIME ZONE

TIMESTAMP

TIMESTAMP WITH TIME ZONE

INTERVAL YEAR
INTERVAL YEAR TO MONTH
INTERVAL MONTH

INTERVAL YEAR

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