The date format in Unix define in environment
In sql you can set default time by alter session set nls_date_format =
<your format>
You probably define it also in database level
When you select date/time from table with no convert you receive the
default
i.e. select sysdate from dual;
The to_char convert date/time to the format you specified (in your query
to 'DD-MON-YYYY HH24:MI:SS')
HTH
Ofer
-----Original Message-----
From: Maya Gopi
[mailto:oracledba-ezmlmshield-x70650167.[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