以下のTeradataデータ型がSCRIPTテーブル演算子でサポートされています。
Teradataデータ型 |
---|
BYTE |
BYTEINT |
SMALLINT |
INTEGER |
BIGINT |
DECIMAL/NUMERIC |
FLOAT/REAL/DOUBLE PRECISION |
NUMBER |
DATE |
TIME |
TIME WITH TIME ZONE |
TIMESTAMP |
TIMESTAMP WITH TIME ZONE |
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 |
CHARACTER |
VARBYTE |
VARCHAR |
CLOB |