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.