Change Your DSN Configuration - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

You can call the SQLDriverConnect or the SQLBrowseConnect API function, and use the new DATETIMEFORMAT = option. The DateTimeFormat is only valid for the duration of the new session. You can also use one of the following SQL statements to permanently set it:

SET SESSION DATEFORM = ANSIDATE
SET SESSION DATEFORM = INTEGERDATE

The DateTimeFormat is only valid for the duration of the session. In addition, the SET SESSION DATEFORM SQL statement must not be included in a multi-statement request. Finally, this method only sets the DATE format.