Re: Storing time values via jdbc thin driver

From: <sybrandb_at_hccnet.nl>
Date: Fri, 28 Nov 2008 22:56:52 +0100
Message-ID: <55q0j4du3b8a6rm5gimuhk76vg8gustddi@4ax.com>


On Fri, 28 Nov 2008 20:06:00 +0100, "Chris Seidel" <cseidel_at_arcor.de> wrote:

>The problem is the switch from 9 to 10.
>
>java-pesudo-query: from foo where time := 10:00:00
>
>oracle-query with 9.2 driver: ... from foo where time = 1900-01-01 10:00:00
>oracle-query with 10.2 driver: ... from foo where time = 1970-01-01 10:00:00
>
>The 10.2-query will not find any records stored with the 9.2 driver.
>
>So it is impossible to used the same database with different drivers.
>
>Right?

Likely nonsense.
You are relying on a default format. The default format may have changed betwseen 9.2 and 10.2. This has happened before and it wouldn't surprise me if it happened again. The timestamp business did change in 10g.
You would need to look this up in the online 10gR2 New Features manual.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Fri Nov 28 2008 - 15:56:52 CST

Original text of this message