cancel
Showing results for 
Search instead for 
Did you mean: 

Urgent help. Time Zone Setting

Kenn Chen
Advisor

Urgent help. Time Zone Setting

currently, my server date and time is same as another server (non-hpux) but the application shown the time is defferent. We suspected is the time zone different. How could check whether our time zone is GMT + 8 or - 8 (-288000). If i want to change the setting , how to change it and any impact of changing this. Thanks.
Cyber Zen
3 REPLIES
Pedro Sousa
Honored Contributor

Re: Urgent help. Time Zone Setting

boley janowski
Trusted Contributor

Re: Urgent help. Time Zone Setting

"date" will tell you the time zone in the 5th field, man date for more info.
R. Allan Hicks
Trusted Contributor

Re: Urgent help. Time Zone Setting

One thing to consider.... If your application gets the date from Oracle (I'm guessing that a database is involved here), the time returned will be in the timezone that was in place on the machine when the listener was started.

If echo $TZ=EST5EDT on the server and you connect scott/tiger then

select sysdate from dual;

will return the prevailing eastern time.

However, if TZ=GMT on the machine where the Oracle listener was started and you
connect scott/tiger@remote_machine then

select sysdate from dual;

will return the time in GMT.

-Good Luck
Allan Hicks
"Only he who attempts the absurd is capable of achieving the impossible