skip to main content
Connection property descriptions : FetchTSWTZAsTimestamp
  

Try DataDirect Drivers Now

FetchTSWTZAsTimestamp

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

setFetchTSWTZAsTimestamp

Default

false

Data type

Boolean

See also

Data type handling properties