ANSI Date and Time Restrictions - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-08-22
dita:mapPath
xbl1544831938754.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities
Some of the restrictions for using ODBC Driver for Teradata include:
  • The SET SESSION DateForm command is not allowed in a multi-statement request
  • The time zone value for TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE must be converted to an ODBC C character type. The standard ODBC C time and timestamp types do not have a time zone component
  • (Windows) Since ODBC Driver for Teradata does not support PMPC commands, asynchronous niching (priority of execution) of a query is not supported, but self-niching queries are supported.
  • The Teradata TIME type allows fractional seconds, but there is limited support for fractional seconds of TIME in standard ODBC. As an extension to standard ODBC, ODBC Driver for Teradata preserves fractional seconds in conversions between character ODBC C data types and SQL_TYPE_TIME.