Xref: alice comp.databases.oracle.misc:57073 comp.databases.oracle.server:90852 comp.databases.oracle.tools:42509
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!cyclone.swbell.net!news.swbell.net.POSTED!not-for-mail
From: "spencer" <spencerp@swbell.net>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
References: <38E9F6BC.31470781@bmc.com> <APnG4.1$s5.71@dit4.state.va.us> <38EA0EB6.43E76828@bmc.com> <hNoG4.2$s5.100@dit4.state.va.us> <38EA3C7D.AB7788E9@bmc.com>
Subject: Re: Help... How to determine GMT time in Oracle?
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <okMH4.1300$Nm2.57736@news.swbell.net>
Date: Sat, 8 Apr 2000 15:08:49 -0500
X-Complaints-To: abuse@swbell.net
X-Trace: news.swbell.net 955224468 208.190.217.46 (Sat, 08 Apr 2000 15:07:48 CDT)
NNTP-Posting-Date: Sat, 08 Apr 2000 15:07:48 CDT
Organization: SBC Internet Services

just a word of caution: AFAIK "undocumented features"
are not supported by Oracle, and are subject to removal
or alteration in a later release.

"Eleanor Sokol" <eleanor_sokol@bmc.com> wrote in message
news:38EA3C7D.AB7788E9@bmc.com...
> Well, the good thing is we are on 8i.  I'll check with our
DBAs for a number
> for OTS and find out how to set up for those "undocumented"
features.
>
> Thanks
> Elly
>
> Alan Moorman wrote:
>
> > Well, I didn't fully read your post.  I searched MetaLink
and it seems that
> > this is a problem which Oracle's addressing in 8i.  There
were some
> > references by people who've written custom code (Java or
external procs) to
> > accomplish this.  The disturbing thing about 8i is that it
looks like the
> > functionality is "hidden" and unpublished.  The suggestion
was to call OTS
> > and ask about how to set up TIME_WITH_TIMEZONE and
TIMESTAMP_WITH_TIMEZONE
> > functionality.  Hope you're on 8i!!
> >
> > Alan
> >
> > Eleanor Sokol wrote in message
<38EA0EB6.43E76828@bmc.com>...
> > >What do you do for the time zones which are not supported
(i.e. Moscow)?
> > >Unfortunately new_time does not support all the time zones
of the world it
> > >seems.
> > >
> > >Elly
> > >
> > >
> > >Alan Moorman wrote:
> > >
> > >> select to_char(new_time(sysdate,'edt','gmt'),'mm-dd-rrrr
hh24:mi:ss')
> > from
> > >> dual;
> > >
>