RE: get UTC date in Oracle 7.3.4

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Tue, 16 Mar 2004 16:49:33 -0600
Message-ID: <A42F529F25C23349B01EEA3170220C560185EF55@MSPM1BMSGM02.ent.core.medtronic.com>

Are the UTC and GMT dates are same.

Somebody told me that the current difference between UTC and GMT is about 21 seconds.

Thanks,
Ashoke
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Marc Perkowitz Sent: Wednesday, March 10, 2004 12:10 PM To: oracle-l_at_freelists.org
Subject: Re: get UTC date in Oracle 7.3.4

If you use this approach, you'll need to change CST to CDT when you're within DST for your timezone.

Original Message ----- From: "Kevin Lange" <klange_at_ppoone.com> To: <oracle-l_at_freelists.org> Sent: Wednesday, March 10, 2004 11:37 AM Subject: RE: get UTC date in Oracle 7.3.4

> How about the NEW_TIME function . Such as :
>
> select to_char(new_time(sysdate,'CST','GMT'),'YYYY-MM-DD-HH24.MI.SS') from
> dual
>
>
>
> -----Original Message-----
> From: Andreas.Haunschmidt_at_voestalpine.com
> [mailto:Andreas.Haunschmidt_at_voestalpine.com]
> Sent: Wednesday, March 10, 2004 11:26 AM
> To: oracle-l_at_freelists.org
> Subject: get UTC date in Oracle 7.3.4
>
>
> Dear List Members!
>
> A collegue running Oracle 7.3.4 needs to get the SYSDATE in UTC (GMT),
> as far as I know, there is no trivial solution to get this done
> in SQL or PL/SQL only.
> We would be grateful, if anyone had a solution...
> Any ideas?
>
> Thanks in advance
>
> Andreas
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Mar 16 2004 - 16:46:24 CST