The following table lists the Analytics Database data types supported by the Teradata SQL Driver for R, and shows the corresponding R data type returned in result set rows.
| Analytics Database data type | Result set R data type |
|---|---|
| BIGINT | bit64::integer64 |
| BLOB | raw |
| BYTE | raw |
| BYTEINT | raw |
| CHAR | character |
| CLOB | character |
| DATE | Date |
| DECIMAL | double |
| FLOAT | double |
| INTEGER | integer |
| INTERVAL YEAR | character |
| INTERVAL YEAR TO MONTH | character |
| INTERVAL MONTH | character |
| INTERVAL DAY | character |
| INTERVAL DAY TO HOUR | character |
| INTERVAL DAY TO MINUTE | character |
| INTERVAL DAY TO SECOND | character |
| INTERVAL HOUR | character |
| INTERVAL HOUR TO MINUTE | character |
| INTERVAL HOUR TO SECOND | character |
| INTERVAL MINUTE | character |
| INTERVAL MINUTE TO SECOND | character |
| INTERVAL SECOND | character |
| NUMBER | double |
| PERIOD(DATE) | character |
| PERIOD(TIME) | character |
| PERIOD(TIME WITH TIME ZONE) | character |
| PERIOD(TIMESTAMP) | character |
| PERIOD(TIMESTAMP WITH TIME ZONE) | character |
| SMALLINT | integer |
| TIME | hms::hms |
| TIME WITH TIME ZONE | character |
| TIMESTAMP | POSIXct |
| TIMESTAMP WITH TIME ZONE | character |
| VARBYTE | raw |
| VARCHAR | character |
The following table lists the parameterized SQL bind-value R data types supported by the Teradata SQL Driver for R, and shows the corresponding Analytics Database data type transmitted to the server.
| Bind-value R data type | Analytics Database data type |
|---|---|
| bit64::integer64 | BIGINT |
| character | VARCHAR |
| Date | DATE |
| difftime | VARCHAR format compatible with INTERVAL DAY TO SECOND |
| double | FLOAT |
| integer | INTEGER |
| hms::hms | TIME |
| POSIXct | TIMESTAMP |
| POSIXlt without $gmtoff | TIMESTAMP |
| POSIXlt with $gmtoff | TIMESTAMP WITH TIME ZONE |
| raw | VARBYTE |
| teradatasql::TimeWithTimeZone | TIME WITH TIME ZONE |
| teradatasql::Timestamp | TIMESTAMP |
| teradatasql::TimestampWithTimeZone | TIMESTAMP WITH TIME ZONE |