Time Zone question
I am running Oracle 10.2.0.4 on HP-UX is 64.
When I issue the following commands the timezones don't match
SQL> SELECT SESSIONTIMEZONE FROM DUAL;
SESSIONTIMEZONE
---------------------------------------------------------------------------
-06:00
SQL> select dbtimezone from dual;
DBTIME
------
-05:00
I am on CST (St Louis, MO). How can I get my DBTIME correct AND why did it go south?
I saw a patch but it looked like it was for versions less than 10.2.0.4? This was a DB upgraded from 9.2.0.8
Thanks
Vince
SQL> SELECT SESSIONTIMEZONE FROM DUAL;
SESSIONTIMEZONE
---------------------------------------------------------------------------
-06:00
SQL> select dbtimezone from dual;
DBTIME
------
-05:00
I am on CST (St Louis, MO). How can I get my DBTIME correct AND why did it go south?
I saw a patch but it looked like it was for versions less than 10.2.0.4? This was a DB upgraded from 9.2.0.8
Thanks
Vince
0