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 -----------------------------------------------------------------