Re: Storing time values via jdbc thin driver

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