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

In article <38E9F6BC.31470781_at_bmc.com>, Eleanor Sokol <eleanor_sokol_at_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_at_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_at_bmc.com
> fn:Eleanor Sokol
> end:vcard
>
> --------------7DB89AA8A1770ECB089685AF--
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 04 2000 - 17:43:01 CEST