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