Purpose

Determines whether column values with the datetimeoffset data type are returned as a JDBC VARCHAR or TIMESTAMP data type.

This property only applies to connections to Azure and SQL Server 2008 and higher.

Valid values

true | false

Behavior

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

If set to false, column values with the datetimeoffset data type are returned as a JDBC VARCHAR data type.

Data source method

public Boolean getFetchTSWTZAsTimestamp()

public void setFetchTSWTZAsTimestamp(Boolean)

Default

false

Data type

Boolean

See also

Connection property descriptions