The Advanced SQL Engine supports ANSI and Integer Session Date Forms. "SET SESSION DATEFORM = ANSIDATE | INTEGERDATE" command allows legacy applications to switch from ANSI (default) to INTEGER date form and back.

By default the Data Provider opens all connections/sessions in ANSI date form. ANSI Date is consistent with Timestamp and Time data types. Therefore it provides the best overall feature and functionality to applications.

The Session DateForm primarily governs how the SQL Engine transmits Date values to the Data Provider. It will not affect the transmission of Date values from the Data Provider to the SQL Engine. The Session DateForm will also impact default date format for CREATE TABLE DDL statements and implicit conversion of Character literals to Date. Please refer to "Date Data Type" section in "SQL Data Types and Literals" manual for additional information on DateForm.

Note
The Data Provider supports Integer Session DateForm when connected to the Teradata Database 12.0.1.2 or higher. The Data Provider will not be able to send Date Parameter values to the Teradata Database 6.2 or earlier when session date form is set to Integer.

The Data Provider supports Integer Date Form for backward compatibility with legacy applications and or scripts. New applications should use ANSI DateForm (default) and ANSI Date literals (i.e. DATE'YYYY-MM-DD').