Re: Storing time values via jdbc thin driver

From: Chris Seidel <>
Date: Fri, 28 Nov 2008 20:52:21 +0100
Message-ID: <49304bf2$0$31876$>

gym dot scuba dot kennedy at gmail wrote:

> I am not sure I understand the question. Wouldn't you be specifying
> the date and the time? In Oracle you don't have just time anyway. You
> have a date and a time. You could have a string field that
> represents a time. (ugh) or you could use some sort of integer to
> represent the time. It looks like you have an impediance mismatch
> between Java and Oracle.

Yes. Java knows Time and Date, Oracle only 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. Received on Fri Nov 28 2008 - 13:52:21 CST

Original text of this message