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

Teradata® R Package User Guide

Product
Teradata R Package
Release Number
16.20
Published
February 2020
Language
English (United States)
Last Update
2022-05-02
dita:mapPath
qbt1519078127352.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-4005
lifecycle
previous
Product Category
Teradata Vantage
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.