Control how datetime columns are retrieved
|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
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 default data type returned for datetime columns
Examples
The following instructs xfODBC to retrieve timestamp columns as SQL_DATE values:
VORTEX_ODBC_DATETIME=9
