skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Oracle Wire Protocol Driver : Connection Option Descriptions : Fetch TSWTZ as Timestamp
  
Fetch TSWTZ as Timestamp
Attribute
FetchTSWTZasTimestamp (FTSWTZAT)
Purpose
Determines whether the driver returns column values with the timestamp with time zone data type as the ODBC data type SQL_TYPE_TIMESTAMP or SQL_VARCHAR.
Valid on Oracle 10g R2 or higher.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the driver returns column values with the timestamp with time zone data type as the ODBC type SQL_TYPE_TIMESTAMP. The time zone information in the fetched value is truncated. Use this value if your application needs to process values the same way as TIMESTAMP columns.
If set to 0 (Disabled), the driver returns column values with the timestamp with time zone data type as the ODBC data type SQL_VARCHAR. Use this value if your application requires the time zone information in the fetched value.
Default
0 (Disabled)
GUI Tab
Advanced tab