Timzone id

[Sonny_8]

Change timezone id
But When I test with JAVA program to produce the date

from ORCALE suuport
java.text.SimpleDateFormat@e3d1e9c0java.util.SimpleTimeZone[id=Asia/Calcutta,off
set=19800000,dstSavings=3600000,useDaylight=false,startYear=0,startMode=0,startM
onth=0,startDay=0,startDayOfWeek=0,startTime=0,startTimeMode=0,endMode=0,endMont
h=0,endDay=0,endDayOfWeek=0,endTime=0,endTimeMode=0]
03/01/2003 19:39:29 India Standard Time$

SP

java.util.SimpleTimeZone[id=Custom,offset=28800000,dstSavings=3600000,useDayligh
t=false,startYear=0,startMode=
0,startMonth=0,startDay=0,startDayOfWeek=0,startTime=0,startTimeMode=0,endMode=0
,endMonth=0,endDay=0,endDayOfW
eek=0,endTime=0,endTimeMode=0]
03/01/2003 14:38:12 GMT+08:00
Fri Jan 03 14:38:12 GMT+08:00 2003


My Question is How to change TimeZone id=Custom to TimeZone id=Asia/Singapore? I mean the steps to do.

[Rajeev Shukla]

Hi,
If you want to change the time zone on the unix server use the command
/sbin/set_parms timezone
this will display the current time zone and you can change then to whatever you like. Take care you'll have to reboot after that.

Cheers
Rajeev

[Sonny_8]

Thanks a lot

[Bill Hassell]

The set_parms program simply sets the /etc/TIMEZONE file that is executed when a user logs in, and it simply sets the environment variable TZ. This does not change the way HP-UX keeps time (which is always GMT or Zulu time), but changes the way that system calls report the time. In this manner, any user can view the time using any timezone (which is ideal for remote logins or international web pages).

To see what timezones are available, look at the file: /usr/lib/tztab and also the man page for tztab. For your Oracle code, just export TZ with the desired timezone and start Oracle.