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

From: Eleanor Sokol <eleanor_sokol_at_bmc.com>
Date: Tue, 04 Apr 2000 14:03:25 -0500
Message-ID: <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_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 Tue Apr 04 2000 - 14:03:25 CDT