Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-04!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Problem with Oracle Timezones Date: Mon, 18 Apr 2005 10:37:07 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1113845604.928467@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1113737110.301348.208030@o13g2000cwo.googlegroups.com> <1113758061.224694@yasure> <1113796238.518823.18430@l41g2000cwc.googlegroups.com> <1113834556.099503.44760@g14g2000cwa.googlegroups.com> In-Reply-To: <1113834556.099503.44760@g14g2000cwa.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 27 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:240686 Tejaswini wrote: > Hi, > > Thanks and Sorry for not giving the necessary details. > > I am trying to execute the query by connecting to a remote machine and > it fails. Local machine has Oracle 9i client on HP-UX and remote > machine has Oracle 9i (Pathset 9.2.0.6)database,server and client and > HP-UX. But when I tried the same query on that remote machine directly, > it is working correctly. > > Here are some timezones I tried: > Pacific/Norfolk :: not working > Europe/London :: working > Europe/Kiev :: not working > Asia/Calcutta :: working. > > > Thanks & Regards, > Tejaswini Sounds to me like someone messed something up. I'd suggest an iTAR. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)