Re: Help... How to determine GMT time in Oracle?

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_at_bmc.com> wrote in message news:38EA3C7D.AB7788E9_at_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_at_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;
> > >
>
Received on Sat Apr 08 2000 - 00:00:00 CDT