Re: Problem with DBTIMEZONE
From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 16 Oct 2008 14:45:09 -0600
Message-ID: <3c5f7820810161345u24f2a175yd0f307e34e67d08d@mail.gmail.com>
-05:00
Date: Thu, 16 Oct 2008 14:45:09 -0600
Message-ID: <3c5f7820810161345u24f2a175yd0f307e34e67d08d@mail.gmail.com>
I agree. They don't. If I'm correct, they have to change ONLY the
function, not a gazillion places in the code. They don't want to search
through their code to look for it, I don't have the access to the JAVA and
SQL Server code, and I have no authority to make them do anything. The
proverbial "rock and a hard place".
Sandy
I believe they could quickly modify their code to use TZ_OFFSET
SQL> select TZ_OFFSET(DBTIMEZONE) from dual;
TZ_OFFS
-05:00
>
>
>
> Bradd Piontek
> "Next to doing a good job yourself,
> the greatest joy is in having someone
> else do a first-class job under your
> direction."
> -- William Feather
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 16 2008 - 15:45:09 CDT