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

Teradata® Package for R User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for R
Release Number
17.20
Published
March 2024
ft:locale
en-US
ft:lastEdition
2024-04-09
dita:mapPath
efv1707506846369.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
nqx1518630623256
lifecycle
latest
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.