Time Zone Information Not Retrieved | Teradata R Package - 17.00 - Time Zone Information Not Retrieved for Time and Timestamp Data Types - Teradata R Package

Teradata® R Package User Guide

prodname
Teradata R Package
vrm_release
17.00
created_date
November 2020
category
User Guide
featnum
B700-4005-090K
This limitation is only applicable when connecting to Vantage with Teradata ODBC Driver.

If a table contains columns with either TIME with TIME ZONE or TIMESTAMP with TIME ZONE data types, then the time zone information present in these columns is not retrieved in the R data frame.

To work around this limitation, convert the TIME with TIME ZONE and TIMESTAMP with TIME ZONE columns to the VARCHAR data type using the as.character SQL translation function.