Wrong Sysdate in the client
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 :-
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
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.
sysdate get the time from the database server, presume you are on a unix variant - run the date command and compare it to select sysdate from dual
also check v$instance to check you actually are connected to the same database, your tnsnames might redirect that SID to a different database
Click Here to Expand Forum to Full Width