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>
>> 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?
>>
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