FetchTSWTZAsTimestamp
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
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 Microsoft SQL Server 2008 and higher and Microsoft Windows Azure SQL Database.
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.
Default
false
Data Type
boolean