The following Teradata Database data types are supported by the SCRIPT table operator.
| Teradata Database Data Type |
|---|
| 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 |