Open topic with navigation
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.
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)
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.
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).
The following instructs xfODBC to retrieve timestamp columns as SQL_DATE values: