Re: Daylight Savings Time Translation Error with Oracle 8i

On Thu, 14 Apr 2005 19:12:30 GMT, David Sanabria <david.sanabria_at_morte_spam.thehartford.mortespam.com> wrote:

>I have attached my date conversion code (inline below) for the benefit
>of all Remedy users. If you can see anything within my code that might
>be a cause of our problems, please let me know. (otherwise, enjoy the code).

Well, it still think it can be accomplished by modifying the TZ environment variable,as I indicated before. Your problem is obviously *Nix and Mickeysoft aren't in agreement about the start and end of DST. I doubt whether it really has anything to do with Remedy, though I admit Remedy is a crap product, which should be thrown away at the first occasion. In our case we were forced to switch the database to noarchivelog, because there was no way to cope with the volume of redolog generated.

--
Sybrand Bakker, Senior Oracle DBA