Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> timestamp question

timestamp question

From: Joe Sath <u705413818_at_spawnkill.ip-mobilphone.net>
Date: Fri, 20 Sep 2002 14:10:34 GMT
Message-ID: <l.1032531035.1436370849@[64.94.198.252]>


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
Received on Fri Sep 20 2002 - 09:10:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US