Re: Storing time values via jdbc thin driver

From: Palooka <nobody_at_nowhere.com>
Date: Fri, 28 Nov 2008 23:55:56 +0000
Message-ID: <gy%Xk.17247$BN5.7561@newsfe01.ams2>


Palooka wrote:

> Chris Seidel wrote:

>> Hi,
>>
>> I have an Oracle 9.2 database.
>> If I use the 9.2 driver java.sql.Time is stored with 1900-01-01 HH:MM.
>> If I use the 10.2 driver java.sql.Time is stored with 1970-01-01 HH:MM.
>>
>> Is this a know bug/feature?
>> Do I have to update all my records to 1970 when using oracle 10 driver?
>>
> Shouldn't matter, should it? If you are only interested in the time, 
> just disregard the date part.
> 
> Palooka

To amplify, yes, Sybrand is correct. You are relying on defaults. Sloppy coding.

Palooka Received on Fri Nov 28 2008 - 17:55:56 CST

Original text of this message