VORTEX_ODBC_DATETIME

The VORTEX_ODBC_DATETIME environment variable determines how datetime columns are retrieved.

Value

One of the following integer values for SQL data types:

1 = Return datetime columns as SQL_CHAR.

9 = Return datetime columns as SQL_DATE.

10 = Return datetime columns as SQL_TIME.

11 = Return datetime columns as SQL_TIMESTAMP. (default)

Discussion

By default, datetime columns are returned as SQL_TIMESTAMP values, but you can change the SQL data type for these columns by setting VORTEX_ODBC_DATETIME to the integer value for a SQL type. For example, to retrieve datetime columns as SQL_DATE values, set VORTEX_ODBC_DATETIME to 9.

Setting location

The system environment. For client/server configurations, VORTEX_ODBC_DATETIME must be set on the client. For a service, such as IIS or SQL Server, you must reboot after setting VORTEX_ODBC_DATETIME, unless you set it in a DSN (see Adding a user or system DSN).