Hi All,
Database version =8.1.7
OS=Solaris 2.7

I have my DB in pacafic time zone, this machine is running multiple instance.One instance has got two schema,.The database is loacted in bangalore(india).The OS TZ is set Pacefic time zone
what i want to do is

a.one schema should show date and time in PST
b.The second schema should show date and time in my local i.e Indian standard time

How can i achive this please help me

regards
anandkl