RE: get UTC date in Oracle 7.3.4
- From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 16:49:33 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Marc Perkowitz
Sent: Wednesday, March 10, 2004 12:10 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxx
> [mailto:Andreas.Haunschmidt@xxxxxxxxxxxxxxx]
> Sent: Wednesday, March 10, 2004 11:26 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts: