Re: Sql*net 5 hours ahead

You should check the timezone "TZ" environment variable of the unix userid running the listener process.
Connections coming into the database via sqlnet will have the timezone of the owner of the Listener process. Connection from the host will have the timezone of the unix user starting the local connection.

Hope this helps.

Christopher Naya <is_at_creditwatch-inc.com> wrote in article <336536C0.2FAA_at_creditwatch-inc.com>...
> Here's one I can't solve yet:
>
> Oracle7 enterprise 7.0.18 running on A/UX (Apple unix)
> SQL*Net 1.5 running on Macintosh front-end.
>
> SELECT TO_CHAR(SYSDATE,'MM/DD/YY HH24:MI') FROM DUAL;
> results in a sysdate which is 5 hours ahead of performing the same query
> in sqldba at the server console.
>
> "date" command at unix console matches sysdate returned via sqldba at
> console; just the variance going across sql*net.
>
> Anyone run into this before?
>
  Received on Tue Apr 29 1997 - 00:00:00 CDT