サポートされる出力データ型 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - JSONデータ型

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/uwa1591040057999.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
evi1472243742653
Product Category
Software
Teradata Vantage

次に、JSON_TABLE出力でサポートされているデータ型のリストを示します。角括弧は、型指定におけるオプションの値を示します。

CHAR(n)
VARCHAR(n)
BYTE(n)
VARBYTE(n)
BYTEINT
SMALLINT
INTEGER
FLOAT/REAL
DECIMAL/NUMERIC [(n,[m])]
NUMBER
DATE
TIME [(fractional_seconds_precision)]
TIME [(fractional_seconds_precision)] WITH TIME ZONE
TIMESTAMP [(fractional_seconds_precision)]
TIMESTAMP [(fractional_seconds_precision)] WITH TIME ZONE
INTERVAL YEAR [(precision)]
INTERVAL YEAR [(precision)] TO MONTH
INTERVAL MONTH [(precision)]
INTERVAL DAY[(precision)]
INTERVAL DAY[(precision)] TO HOUR
INTERVAL DAY[(precision)] TO MINUTE
INTERVAL DAY [(precision)] TO SECOND
INTERVAL HOUR [(precision)]
INTERVAL HOUR [(precision)] TO MINUTE
INTERVAL HOUR [(precision)] TO SECOND
INTERVAL MINUTE [(precision)]
INTERVAL MINUTE [(precision)] TO SECOND
INTERVAL SECOND [(fractional_seconds_precision)]