Re: Storing time values via jdbc thin driver

From: <sybrandb_at_hccnet.nl>
Date: Fri, 28 Nov 2008 22:57:58 +0100
Message-ID: <i9q0j41fvclsjbut0vqhh8hjhp9r8nhmas@4ax.com>


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

>
>Yes. Java knows Time and Date, Oracle only Date.
Actually this utter nonsense. The date data type stores both time and date.
>Java says that for time the date part must be set to 1970-01-01.
>But it seems the 9.2 driver sets it to 1900-01-01.
>Now all my queries are broken with a 10.2 driver.
>

This is because you are relying on a default format.

Sybrand Bakker
Senior Oracle DBA Received on Fri Nov 28 2008 - 15:57:58 CST

Original text of this message