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










Oracle LazyDBA home page