I am using oracle 8.1.7 in Solaris. When I issued the sysdate command, it is returning two different value..

From the local system, SQL*Plus client returns the correct date and time, compared to the local system clock. But when I run the same query from a remote SQL*Plus session returns the incorrect time

I tried the following steps in my database:-

Step 1 :-
export ORACLE_SID=SID
sqlplus user
sql > select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;

which sets up a local connection, I get the correct time.

Step 2 :-
In the same database server system, I connected to database by using @SID

sqlplus user@SID
Sql > select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;


getting effectively a remote connection, I get the incorrect time.

I restarted the listener, to make sure TZ variable in shell. But still I am spacing the same problem.


Note :- I am sure that, I am connecting to same database server.
Any help on this would be appreciated.