skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Connection Option Descriptions : Fetch Time Stamp With Time Zone as Timestamp
  
Fetch Time Stamp With Time Zone as Timestamp
Attribute
FetchTSWTZasTimestamp
Purpose
Determines whether the driver returns Timestamp with Time Zone columns as an ODBC SQL_TYPE_TIMESTAMP or as a SQL_VARCHAR data type.
Valid only for DB2 for z/OS, version 10 or higher.
Valid Values
0 | 1
Behavior
If set to 0 (Disabled), Timestamp with Time Zone columns are mapped to SQL_VARCHAR. Use this setting if your application needs to retrieve the information as a string.
If set to 1 (Enabled), the driver maps Timestamp with Time Zone columns to the ODBC SQL_TYPE_TIMESTAMP data type. The time zone information is truncated from the results.
Default
0 (Disabled)
GUI Tab
Advanced tab