Describe time columns as SQL_TIME or SQL_TIMESTAMP
|
WTSupported in traditional Synergy on Windows
|
WNSupported in Synergy .NET on Windows
|
|
|
The VORTEX_ODBC_TIME environment variable determines how time columns are described.
Value
One of the following values:
10 = Describe time columns as SQL_TIME. (default)
11 = Describe time columns as SQL_TIMESTAMP.
Discussion
ADO.NET retrieves SQL_TIME columns (the default data type for time columns in xfODBC) as System.TimeSpan, which is a .NET data type that represents a time interval, rather than a specific time. So unless an application is written to use a time interval, the time must generally be calculated from timespan values. VORTEX_ODBC_TIME, however, can make these calculations unnecessary by instructing the xfODBC driver to describe time columns as SQL_TIMESTAMP. Note the following:
- If VORTEX_ODBC_TIME is not set (which is the default), the xfODBC driver describes time columns as SQL_TIME.
- SQL_TIMESTAMP values have both a date and a time, so to create a SQL_TIMESTAMP value, xfODBC includes the date 1-1-1.
Setting location
The system environment. For client/server configurations, VORTEX_ODBC_TIME must be set on the client. For a service, such as IIS or SQL Server, you must reboot after setting VORTEX_ODBC_TIME, unless you set it in a DSN (see Adding a user or system DSN).
Used by
xfODBC
See also
Examples
VORTEX_ODBC_TIME=11
