Change Your DSN Configuration

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

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.