The following lists the supported data types for JSON_TABLE output. The square brackets indicate optional values in the type specification.
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)] |