Fetch TSWTZ as Timestamp
- Last Updated: August 5, 2021
- 1 minute read
- DataDirect Connectors
- ODBC
- PostgreSQL 8.0
- Documentation
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 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)