Hi,
The problem has been resolved by restarting my listener.
Note
-----
Check that the time in the banner of sqlplus ( SQL*Plus: Release
10.1.0.4.0 - Production on Wo Jan 11 15:05:46 2006 ) is reflecting the
time based on the current TZ set in the Unix (!) session.
If the results are different this means that the listener is started
with a different TZ then you current user environment. To resolve this
simply stop and start listener with the TZ you want to use. if you are
using MTS then you might see a correct result with a dedicated
connection, in that case stop and start also the database with the
correct TZ.
Regards
-----Original Message-----
From: Maya Gopi
[Email address protected]
Sent: Tuesday, October 31, 2006 10:41 AM
To: LazyDBA Discussion
Subject: Difference in time between Database and the Unix server.
Hi Gurus,
The time shown in my server is as follows:
# date
Tue Oct 31 11:40:16 SAUST 2006
From sqlplus (From DB server) when I selected sysdate, I am getting the
following time
select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') todaytime from dual;
TODAYTIME
--------------------
31-OCT-2006 10:36:06
Can anyone tell me why this time difference. In the database server the
time is shown correctly, where as from sql it shows a different time.
From where does the database pick the time.
regards
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
The information contained in this e-mail message may be
privileged and confidential. The information is intended only
for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the message
from your computer. Thank you!
Unless otherwise stated, any views or opinions expressed in
this e-mail are solely those of the author and do not represent those of
Barak I.T.C (1995) The International Telecommunications Services Corp.
Ltd.
**********************************************************************
Oracle LazyDBA home page