VORTEX_ODBC_DATETIME

Control how datetime columns are retrieved

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX
VSupported on OpenVMS

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).

Used by

xfODBC.

See also

Changing the data type returned for datetime columns.

Examples

The following instructs xfODBC to retrieve timestamp columns as SQL_DATE values:

VORTEX_ODBC_DATETIME=9