Purpose

Determines whether column values with the TIMESTAMP WITH TIME ZONE data type are returned as a JDBC CHAR or TIMESTAMP data type.

This property only applies to connections to Oracle9i and higher.

Valid values

true | false

Behavior

If set to true, column values with the TIMESTAMP WITH TIME ZONE data type are returned as a JDBC TIMESTAMP data type.

If set to false, column values with the TIMESTAMP WITH TIME ZONE data type are returned as a JDBC VARCHAR data type.

Data source method

setFetchTSWTZasTimestamp

Default

false

Data type

boolean

See also

TIMESTAMP WITH TIME ZONE data type