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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help... How to determine GMT time in Oracle?

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

From: Steve A <steve_at_micromark.com.cn>
Date: Fri, 7 Apr 2000 08:46:57 +0800
Message-ID: <1e8oho4.1sipp1i18blobsN%steve@micromark.com.cn>


maybe you can pass it on when you do.

steve

Eleanor Sokol <eleanor_sokol_at_bmc.com> wrote:

> This is a multi-part message in MIME format.
> --------------DAB9B66837FA237ABEE27478
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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;
> > >
>
> --------------DAB9B66837FA237ABEE27478
> Content-Type: text/x-vcard; charset=us-ascii;
> name="eleanor_sokol.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Eleanor Sokol
> Content-Disposition: attachment;
> filename="eleanor_sokol.vcf"
>
> begin:vcard
> n:Sokol;Eleanor
> tel;work:713 918 5215
> x-mozilla-html:FALSE
> adr:;;;;;;
> version:2.1
> email;internet:eleanor_sokol_at_bmc.com
> fn:Eleanor Sokol
> end:vcard
>
> --------------DAB9B66837FA237ABEE27478--
Received on Thu Apr 06 2000 - 19:46:57 CDT

Original text of this message

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