My Oracle Support Banner

JDBC 11g: Timestamp to Date Mapping (Doc ID 1097386.1)

Last updated on MARCH 02, 2019

Applies to:

JDBC - Version 11.1.0.6 to 11.2.0.4.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Goal

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:



Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.