timestamp question

We are using Oracle 9.2.
I need a way to figure out what time is it at certain time zone. Say what is the time at US/Pacific now.

This is how I do it.

select to_char((sysdate - (substr(tz_offset('US/Pacific'),3,1) -   substr(tz_offset('US/Eastern'),3,1))/24),'yyyy/mm/dd hh24:mi:ss')  from dual  

But it looks ugly.
Is there any better way of doing it?

Thanks  

-- 
Sent  by joebayerii from hotmail part of  com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new