could not get the database date 1

[rk0000]

hi
We have oracle 8.1.6 installed on IBM AIX machine.
At command prompt
$date
Tue Aug 27 03:04:03 PDT 2002
$sqlplus login/passwd
SQL> select sysdate from dual;
SYSDATE
--------------------
27-AUG-2002 03:04:15

IT is same the OS date. Note here that i have not given the connect string. Now i exit from sql
again from prompt
$sqlplus login/passwd@db_name
SQL> select sysdate from dual;
SYSDATE
--------------------
27-AUG-2002 10:04:38
This is GMT time. (Our DB is set to GMT). Why this difference comming when i give the connect string. I want date should be always be the date of DB. What should i do?
Thank u
Rama

 

[ThomVF]

Good question! I found some info:

=====================================================
source: rajeev nadimpalli

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci826633,00.html

When you run a query on Unix such as "select sysdate from dual" it will return the system current date and time, which is the same as the OS current date and time. When "select sysdate from dual" is run through SQL*Net, Oracle will use the time zone based on the setting of the UNIX environment variable "TZ" for the user who started the listener.

=====================================================

I would check the TX setting for the account you started ORACLE and the listener with, against the timezone of the server. Perhaps you can align them to get what you want.


Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[rk0000]

what u said is right . The problem is solved.
Thank u Thomas .