Fetch Time Stamp With Time Zone as Timestamp
- Last Updated: April 6, 2022
- 1 minute read
- DataDirect Connectors
- ODBC
- IBM Db2 8.0
- Documentation
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)