有効なfromsqlデータ変換機能 - 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

以下の表で、fromsql機能に有効なターゲットを説明します。

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

LOB

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

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