Re: function to get GMT time

I know, it works! RBG
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, April 03, 2001 2:57 PM

> Ruth:
>
> Just reverse the logic...this converts Eastern Daylight Time to GMT:
> SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual;
>
> SQL> SELECT sysdate FROM dual;
>
> SYSDATE
> --------------------
> 03-APR-2001 13:51:35
>
> SQL> SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual;
>
> NEW_TIME(SYSDATE,'ED
> --------------------
> 03-APR-2001 17:52:06
>
> Kevin Toepke
>
> -------------------------
> The information in this electronic mail message is Cendant Confidential
> and may be legally privileged. It is intended solely for the
> addressee(s). Access to this Internet electronic mail message by anyone
> else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or action taken or omitted to be taken
> in reliance on it is prohibited and may be unlawful.
> -------------------------
> The sender believes that this E-mail and any attachments were free of
> any virus, worm, Trojan horse, and/or malicious code when sent. This
> message and its attachments could have been infected during
> transmission. By reading the message and opening any attachments, the
> recipient accepts full responsibility for taking protective and remedial
> action about viruses and other defects. Cendant Corporation is not
> liable for any loss or damage arising in any way from this message or
> its attachments.
> -------------------------
> <SNIP>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Toepke, Kevin M
> INET: ktoepke_at_cms.cendant.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).