From: jeanch@my-deja.com
Subject: Re: Help... How to determine GMT time in Oracle?
Date: 2000/04/04
Message-ID: <8cd2i2$45p$1@nnrp1.deja.com>#1/1
References: <38E9F6BC.31470781@bmc.com>
X-Http-Proxy: 1.0 x29.deja.com:80 (Squid/1.1.22) for client 192.6.126.68
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Tue Apr 04 15:43:01 2000 GMT
X-MyDeja-Info: XMYDJUIDjeanch
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt; Aim Package version 1.07.8)


In article <38E9F6BC.31470781@bmc.com>,
Eleanor Sokol <eleanor_sokol@bmc.com> wrote:
> This is a multi-part message in MIME format.
> --------------7DB89AA8A1770ECB089685AF
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi...
>
> I need to be able to convert sysdate to GMT time. Is there an way to
 do
> that with Oracle? I've looked at new_time but it only does certain
time
select new_time(sysdate,'GMT','GMT') from dual

That should do it !!!
> zones not all.
>
> I guess the other questions are can I determine:
> 1. Current time zone (i.e . CST or CDT)
> 2. The time offset from GMT
>
> Thanks in advance for any help. I'd appreciate it if you would also
> email your suggestions to: eleanor_sokol@bmc.com.
>
> --------------7DB89AA8A1770ECB089685AF
> 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@bmc.com
> fn:Eleanor Sokol
> end:vcard
>
> --------------7DB89AA8A1770ECB089685AF--
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.