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
-----------------------------------------------------------------
Received on Wed Mar 10 2004 - 12:01:01 CST
