Sql*net 5 hours ahead

From: Christopher Naya <is_at_creditwatch-inc.com>
Date: 1997/04/28
Message-ID: <336536C0.2FAA@creditwatch-inc.com>#1/1

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 Mon Apr 28 1997 - 00:00:00 CDT