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)] |