JDBC 11g: Timestamp to Date Mapping
(Doc ID 1097386.1)
Last updated on MARCH 02, 2019
Applies to:JDBC - Version 126.96.36.199 to 188.8.131.52.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.
In JDBC 10g, there was the property V8Compatible which allowed for Timestamp to Date conversion. This property has now been deprecated in 11g and should no longer be used.
When inserting a Timestamp value into a Date column, and then selecting this inserted value from the database you will see that the inserted value is no longer identical with the stored value when using the 11g driver.
Running the following example, clarifies this. Here we see the results from running the same example using different drivers.
Using oracle.jdbc.V8Compatible set to true, the results returned for the 10g driver is:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document