Database Administration (MOSC)

MOSC Banner

Time Zone question

edited Nov 2, 2009 4:31AM in Database Administration (MOSC) 3 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center