Urgent help. Time Zone Setting

[Kenn Chen]

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.

[Pedro Sousa]

Hi Chen!
check this out:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x5cb353921f1ad5118fef0090279cd0f9,00.html
good luck.

[boley janowski]

"date" will tell you the time zone in the 5th field, man date for more info.

[R. Allan Hicks]

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