有効なtosqlデータ変換機能 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 詳細トピック

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
2020年6月
Language
日本語
Last Update
2021-03-30
dita:mapPath
ja-JP/jpx1556733107962.ditamap
dita:ditavalPath
ja-JP/jpx1556733107962.ditaval
dita:id
B035-1184
Product Category
Software
Teradata Vantage

以下の表で、tosql機能に有効な入力内容を説明します。

ソースの入力値 ルーチン定義のソース データ型 ルーチン定義のターゲット データ型 ターゲットの出力
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