Oracle 9.2.0.5
HPUX 11x

Okay, we are in the Central time zone. I need everything to return Central time. Please review these two scenarios for me, I just can't find out what is wrong.

Connecting as a "bequeath" connection:

hpux71:/home/oracle-> sqlplus "/ as sysdba"

SQL> select dbtimezone from dual;

DBTIME
------
-05:00

SQL> select sessiontimezone from dual;

SESSIONTIMEZONE
--------------------------------------
-05:00

SQL> select systimestamp from dual;

SYSTIMESTAMP
-------------------------------------
24-APR-07 11.22.57.787696 AM -05:00

SQL> select current_timestamp from dual;

CURRENT_TIMESTAMP
--------------------------------------
24-APR-07 11.23.05.459675 AM -05:00

SQL> select to_char(sysdate, 'hh:mi:ss') from dual;

TO_CHAR(
--------
11:23:12

Everything looks okay, huh? It all matches up. Well....

Connecting via SQL*Plus:

hpux71:/home/oracle-> sqlplus cms@cmsdb

SQL> select dbtimezone from dual;

DBTIME
------
-05:00

SQL> select sessiontimezone from dual;

SESSIONTIMEZONE
--------------------------------------
-05:00

SQL> select systimestamp from dual;

SYSTIMESTAMP
-------------------------------------
24-APR-07 12.26.34.373524 PM -04:00 <-----<<< HUH?

SQL> select current_timestamp from dual;

CURRENT_TIMESTAMP
--------------------------------------
24-APR-07 11.26.39.214008 AM -05:00

SQL> select to_char(sysdate, 'hh:mi:ss') from dual;

TO_CHAR(
--------
12:26:45 <----<<< HUH?

I checked with the UNIX guys and the OS TZ parameter is set to "CST6CDT" and the OS seems to check out. The Oracle session has the correctly sourced TZ parameter as CST6CDT as well.

What am I missing? What else do I need to check? I'm outta answers.

Thank you for any info you may have...

Jody.