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