Daylight Savings Time Translation Error with Oracle 8i

From: David Sanabria <david.sanabria_at_morte_spam.thehartford.mortespam.com>
Date: Tue, 12 Apr 2005 15:15:00 GMT
Message-ID: <UBR6e.761$bc2.681@newssvr17.news.prodigy.com>

I am having problems with getting dates out of Oracle since DST began. My problem is that I am converting an EPOCH date from seconds to the native Oracle DATE on the server and once I pull the data out through ODBC or ADO, the dates are getting set to GMT -5 rather than GMT - 4.

I have tried the following:

Used Perl DBD::Oracle to retreive data: Success, dates not affected
ADO via VBScript 5.5: Failure. Times in April affset by -5
ADO via Crystal Reports 9 with latest service pack: Failure, dates in april offset by -5
ODBC via Crystal Reports: Failure. times ofset by -5

I am using Oracle 8.1.7.4. Oracle client version 9.2 and 10.1. ORacle ADO and MS ADO. Oracle ADO connects but times are wrong, MS ADO fails becuase it doesn't like CLOBS.

I would apreciate any thoughts and suggestions.

TIA,
Dave

N. David Sanabria
Specialist, DA
The Hartford, Infrastructure Solutions Department Online Services Information Delivery
W: 1.860.547.7786 * M: 1.860.916.3489
@: david.sanabria_at_thehartford.morte.spam.com Don't be afraid to take a big step if one is indicated; you can't cross a chasm in two small jumps. David Lloyd George Received on Tue Apr 12 2005 - 10:15:00 CDT